PJC_BC_PACKETS_T_BURDEN_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

PROCESS_ID SOURCE_LINE_ID_CHAR_1 SOURCE_LINE_ID_CHAR_2 SOURCE_LINE_ID_CHAR_3 SOURCE_LINE_ID_CHAR_4 SOURCE_LINE_ID_CHAR_5 SOURCE_LINE_ID_NUM_1 SOURCE_LINE_ID_NUM_2 SOURCE_LINE_ID_NUM_3 SOURCE_LINE_ID_NUM_4 SOURCE_LINE_ID_NUM_5 SOURCE_HEADER_ID_CHAR_1 SOURCE_HEADER_ID_CHAR_2 SOURCE_HEADER_ID_CHAR_3 SOURCE_HEADER_ID_CHAR_4 SOURCE_HEADER_ID_NUM_1 SOURCE_HEADER_ID_NUM_2 SOURCE_HEADER_ID_NUM_3 SOURCE_HEADER_ID_NUM_4 PROJECT_ID TASK_ID RBS_ELEMENT_ID K_HEADER_ID K_LINE_ID FUND_ALLOCATION_ID CLOSE_PRIOR_FLAG ACCOUNT_PRIOR_FLAG EXPENDITURE_TYPE_ID ENTERED_CURRENCY ENTERED_DR ENTERED_CR ACCOUNTED_CURRENCY ACCOUNTED_DR ACCOUNTED_CR ACCOUNTING_LEDGER_ID BUDGET_DATE ACCOUNTING_DATE CODE_COMBINATION_ID BALANCE_TYPE_CODE BALANCE_SUBTYPE_ID BC_PACKET_ID PARENT_BC_PACKET_ID

Query

SQL_Statement

SELECT -1 PROCESS_ID, NULL SOURCE_LINE_ID_CHAR_1, NULL SOURCE_LINE_ID_CHAR_2, NULL SOURCE_LINE_ID_CHAR_3, NULL SOURCE_LINE_ID_CHAR_4, NULL SOURCE_LINE_ID_CHAR_5, bc.DOCUMENT_DISTRIBUTION_ID SOURCE_LINE_ID_NUM_1, NULL SOURCE_LINE_ID_NUM_2, NULL SOURCE_LINE_ID_NUM_3, NULL SOURCE_LINE_ID_NUM_4, NULL SOURCE_LINE_ID_NUM_5, NULL SOURCE_HEADER_ID_CHAR_1, NULL SOURCE_HEADER_ID_CHAR_2, NULL SOURCE_HEADER_ID_CHAR_3, NULL SOURCE_HEADER_ID_CHAR_4, bc.DOCUMENT_HEADER_ID SOURCE_HEADER_ID_NUM_1, NULL SOURCE_HEADER_ID_NUM_2, NULL SOURCE_HEADER_ID_NUM_3, NULL SOURCE_HEADER_ID_NUM_4, bc.PROJECT_ID PROJECT_ID, bc.TASK_ID TASK_ID, bc.RBS_ELEMENT_ID RBS_ELEMENT_ID, NULL K_HEADER_ID, NULL K_LINE_ID, NULL FUND_ALLOCATION_ID, NULL CLOSE_PRIOR_FLAG, NULL ACCOUNT_PRIOR_FLAG, bc.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, bc.ENTERED_CURRENCY_CODE ENTERED_CURRENCY, bc.ENTERED_DR ENTERED_DR, bc.ENTERED_CR ENTERED_CR, bc.ACCOUNTED_CURRENCY_CODE ACCOUNTED_CURRENCY, bc.ACCOUNTED_DR ACCOUNTED_DR, bc.ACCOUNTED_CR ACCOUNTED_CR, bc.ACCOUNTING_LEDGER_ID ACCOUNTING_LEDGER_ID, bc.BUDGET_DATE BUDGET_DATE, bc.GL_DATE ACCOUNTING_DATE, NULL CODE_COMBINATION_ID, bc.BALANCE_TYPE_CODE BALANCE_TYPE_CODE, bc.BALANCE_SUBTYPE_ID BALANCE_SUBTYPE_ID, bc.BC_PACKET_ID BC_PACKET_ID, bc.PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID FROM PJC_BC_PACKETS_T bc WHERE bc.packet_id = -1 AND bc.parent_bc_packet_id is not null AND bc.status_code ='P'