1. Tables and Views for Project Management
  2. PJC_AWARD_DISTRIBUTION_V

PJC_AWARD_DISTRIBUTION_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

AWARD_DISTRIBUTION_LINE_ID

AWARD_DISTRIBUTION_ID

AWARD_DISTRIBUTION_BATCH_ID

AWARD_DISTRIBUTION_STATUS

TRANSACTION_NUMBER

SOURCE_LINE_ID_1

SOURCE_LINE_ID_2

SOURCE_LINE_ID_3

SOURCE_LINE_ID_4

SOURCE_LINE_ID_5

SOURCE_LINE_ID_6

DISTRIBUTE_PATTERN_ID

DISTRIBUTE_PATTERN_SET_ID

DISTRIBUTION_SET_PRECEDENCE

DISTRIBUTE_PATTERN_RULE_ID

DISTRIBUTE_RULE_SET_NUMBER

DISTRIBUTION_PERCENTAGE

CONTRACT_ID

FUNDING_SOURCE_ID

DENOM_RAW_COST

DENOM_BURDENED_COST

ACCT_RAW_COST

ACCT_BURDENED_COST

QUANTITY

DIST_BASE_AMOUNT

DIST_DENOM_BURDENED_COST

DIST_ACCT_RAW_COST

DIST_ACCT_BURDENED_COST

DIST_BASE_QUANTITY

VALIDATION_STATUS_CODE

BUDGETARY_CONTROL_VAL_STATUS

Query

SQL_Statement

SELECT

l.AWARD_DISTRIBUTION_LINE_ID AWARD_DISTRIBUTION_LINE_ID,

l.AWARD_DISTRIBUTION_ID AWARD_DISTRIBUTION_ID,

h.AWARD_DISTRIBUTION_BATCH_ID AWARD_DISTRIBUTION_BATCH_ID,

l.AWARD_DISTRIBUTION_STATUS AWARD_DISTRIBUTION_STATUS,

h.TRANSACTION_NUMBER TRANSACTION_NUMBER,

h.SOURCE_LINE_ID_1 SOURCE_LINE_ID_1,

h.SOURCE_LINE_ID_2 SOURCE_LINE_ID_2,

h.SOURCE_LINE_ID_3 SOURCE_LINE_ID_3,

h.SOURCE_LINE_ID_4 SOURCE_LINE_ID_4,

h.SOURCE_LINE_ID_5 SOURCE_LINE_ID_5,

h.SOURCE_LINE_ID_6 SOURCE_LINE_ID_6,

h.DISTRIBUTE_PATTERN_ID DISTRIBUTE_PATTERN_ID,

l.DISTRIBUTE_PATTERN_SET_ID DISTRIBUTE_PATTERN_SET_ID,

l.DISTRIBUTION_SET_PRECEDENCE DISTRIBUTION_SET_PRECEDENCE,

l.DISTRIBUTE_PATTERN_RULE_ID DISTRIBUTE_PATTERN_RULE_ID,

l.DISTRIBUTE_RULE_SET_NUMBER DISTRIBUTE_RULE_SET_NUMBER,

l.DISTRIBUTION_PERCENTAGE DISTRIBUTION_PERCENTAGE,

l.CONTRACT_ID CONTRACT_ID,

l.FUNDING_SOURCE_ID FUNDING_SOURCE_ID,

l.DENOM_RAW_COST DENOM_RAW_COST,

l.DENOM_BURDENED_COST DENOM_BURDENED_COST,

l.ACCT_RAW_COST ACCT_RAW_COST,

l.ACCT_BURDENED_COST ACCT_BURDENED_COST,

l.QUANTITY QUANTITY,

l.DIST_BASE_AMOUNT DIST_BASE_AMOUNT,

l.DIST_DENOM_BURDENED_COST DIST_DENOM_BURDENED_COST,

l.DIST_ACCT_RAW_COST DIST_ACCT_RAW_COST,

l.DIST_ACCT_BURDENED_COST DIST_ACCT_BURDENED_COST,

l.DIST_BASE_QUANTITY DIST_BASE_QUANTITY,

l.VALIDATION_STATUS_CODE VALIDATION_STATUS_CODE,

l.BUDGETARY_CONTROL_VAL_STATUS BUDGETARY_CONTROL_VAL_STATUS

FROM

pjc_award_distribution_lines l,

pjc_award_distributions h

WHERE

l.AWARD_DISTRIBUTION_ID = h.AWARD_DISTRIBUTION_ID

AND l.DISTRIBUTE_PATTERN_SET_ID = h.DISTRIBUTE_PATTERN_SET_ID

AND h.AWARD_DISTRIBUTION_STATUS = 'C'