XCC_PJC_BURDEN_EXTRACT_V

Details

• Schema: FUSION

• Object owner: XCC

• Object type: VIEW

Columns

Name

SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 PJC_PROJECT_ID PJC_TASK_ID PJC_TOP_TASK_ID PJC_RESOURCE_ID PJC_TOP_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID VENDOR_ID INVENTORY_ITEM_ID ORDER_TYPE_INFO CODE_COMBINATION_ID DATA_SET_ID NEED_RESOURCE_FLAG NEED_ACCOUNT_FLAG HEADER_NUM LINE_NUM TR_LINES_ROWID SOURCE_TRANSACTION_TYPE_CODE PJC_FUNDING_SOURCE_ID

Query

SQL_Statement

SELECT ln.source_line_id_1, ln.source_line_id_2, ln.source_line_id_3, ln.source_line_id_4, ln.source_line_id_5, ln.source_line_id_6, ln.pjc_project_id, ln.pjc_task_id, ln.pjc_top_task_id, ln.pjc_resource_id, ln.pjc_top_resource_id, ln.pjc_contract_id, ln.pjc_contract_line_id, ln.pjc_funding_allocation_id, ln.pjc_billable_flag, ln.pjc_capitalizable_flag, ln.pjc_expenditure_type_id, ln.pjc_expenditure_item_date, ln.pjc_organization_id, ln.pjc_work_type_id, ln.VENDOR_ID, ln.INVENTORY_ITEM_ID, ln.ORDER_TYPE_INFO, ln.CODE_COMBINATION_ID, ln.data_set_id, 'Y' need_resource_flag, 'Y' need_account_flag, ln.header_num, ln.line_num, ln.rowid tr_lines_rowid, ln.source_transaction_type_code, ln.pjc_funding_source_id FROM xcc_tr_lines ln WHERE ln.pjc_project_id is not null AND ln.result_code NOT IN ('NOT_APPLICABLE', 'FAILED', 'NO_CONTROL_BUDGET')