PJC_XLA_ITEM_CAT_REF

Details

Schema: FUSION
Object owner: PJC
Object type: VIEW

Columns

Name
EXP_ITEM_ID ITEM_CATEGORY

Name

EXP_ITEM_ID

ITEM_CATEGORY

Query

SQL_Statement
SELECT EXP.EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL.CATEGORY_ID ITEM_CATEGORY FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL WHERE EXP.TRANSACTION_SOURCE_ID = TSRC.TRANSACTION_SOURCE_ID AND TSRC.TRANSACTION_SOURCE = 'OSCM' AND TSRC.PREDEFINED_FLAG = 'Y' AND POL.PO_LINE_ID = EXP.PARENT_LINE_NUMBER UNION ALL SELECT EXP.EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL.CATEGORY_ID ITEM_CATEGORY FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL, AP_INVOICE_DISTRIBUTIONS_ALL APDIST, PO_DISTRIBUTIONS_ALL PODIST, PO_LINE_LOCATIONS_ALL PLL WHERE PODIST.PO_DISTRIBUTION_ID = APDIST.PO_DISTRIBUTION_ID AND EXP.TRANSACTION_SOURCE_ID = TSRC.TRANSACTION_SOURCE_ID AND APDIST.INVOICE_DISTRIBUTION_ID = EXP.PARENT_LINE_NUMBER AND POL.PO_LINE_ID = PLL.PO_LINE_ID AND PLL.LINE_LOCATION_ID = PODIST.LINE_LOCATION_ID AND TSRC.TRANSACTION_SOURCE = 'OAP' AND TSRC.PREDEFINED_FLAG = 'Y'

SQL_Statement

SELECT EXP.EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL.CATEGORY_ID ITEM_CATEGORY

FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL

WHERE EXP.TRANSACTION_SOURCE_ID = TSRC.TRANSACTION_SOURCE_ID

AND TSRC.TRANSACTION_SOURCE = 'OSCM'

AND TSRC.PREDEFINED_FLAG = 'Y'

AND POL.PO_LINE_ID = EXP.PARENT_LINE_NUMBER

UNION ALL

SELECT EXP.EXPENDITURE_ITEM_ID EXP_ITEM_ID, POL.CATEGORY_ID ITEM_CATEGORY

FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL, AP_INVOICE_DISTRIBUTIONS_ALL APDIST, PO_DISTRIBUTIONS_ALL PODIST, PO_LINE_LOCATIONS_ALL PLL

WHERE PODIST.PO_DISTRIBUTION_ID = APDIST.PO_DISTRIBUTION_ID

AND EXP.TRANSACTION_SOURCE_ID = TSRC.TRANSACTION_SOURCE_ID

AND APDIST.INVOICE_DISTRIBUTION_ID = EXP.PARENT_LINE_NUMBER

AND POL.PO_LINE_ID = PLL.PO_LINE_ID

AND PLL.LINE_LOCATION_ID = PODIST.LINE_LOCATION_ID

AND TSRC.TRANSACTION_SOURCE = 'OAP'

AND TSRC.PREDEFINED_FLAG = 'Y'