INV_TRANSFER_ORDER_PJC_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

PJC_CONTEXT_CATEGORY PJC_PROJECT_ID PJC_TASK_ID PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_WORK_TYPE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID REQ_DISTRIBUTION_ID DISTRIBUTION_ID DISTRIBUTION_NUMBER PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OUTSTANDING_QUANTITY OUTSTANDING_AMOUNT REQUESTER_ID REQUISITION_ID REQUISITION_LINE_ID LINE_NUMBER LINE_ID INVENTORY_ITEM_ID ITEM_NUMBER DESCRIPTION QTY_UOM_CODE CURRENCY_CODE DESTINATION_TYPE_LOOKUP UNIT_PRICE HEADER_NUMBER HEADER_ID REQ_BU_ID APPROVED_FLAG SOURCE_TYPE_LOOKUP PROJECT_TYPE_ID COST_COLL_EXCLUDED

Query

SQL_Statement

SELECT DIST.PJC_CONTEXT_CATEGORY ,DIST.PJC_PROJECT_ID ,DIST.PJC_TASK_ID ,DIST.PJC_EXPENDITURE_TYPE_ID ,DIST.PJC_EXPENDITURE_ITEM_DATE ,DIST.PJC_ORGANIZATION_ID ,DIST.PJC_BILLABLE_FLAG ,DIST.PJC_CAPITALIZABLE_FLAG ,DIST.PJC_WORK_TYPE_ID ,DIST.PJC_CONTRACT_ID ,DIST.PJC_CONTRACT_LINE_ID ,DIST.PJC_FUNDING_ALLOCATION_ID ,DIST.REQ_DISTRIBUTION_ID ,DIST.DISTRIBUTION_ID ,DIST.DISTRIBUTION_NUMBER ,DIST.PJC_RESERVED_ATTRIBUTE1 ,DIST.PJC_RESERVED_ATTRIBUTE2 ,DIST.PJC_RESERVED_ATTRIBUTE3 ,DIST.PJC_RESERVED_ATTRIBUTE4 ,DIST.PJC_RESERVED_ATTRIBUTE5 ,DIST.PJC_RESERVED_ATTRIBUTE6 ,DIST.PJC_RESERVED_ATTRIBUTE7 ,DIST.PJC_RESERVED_ATTRIBUTE8 ,DIST.PJC_RESERVED_ATTRIBUTE9 ,DIST.PJC_RESERVED_ATTRIBUTE10 ,DIST.PJC_USER_DEF_ATTRIBUTE1 ,DIST.PJC_USER_DEF_ATTRIBUTE2 ,DIST.PJC_USER_DEF_ATTRIBUTE3 ,DIST.PJC_USER_DEF_ATTRIBUTE4 ,DIST.PJC_USER_DEF_ATTRIBUTE5 ,DIST.PJC_USER_DEF_ATTRIBUTE6 ,DIST.PJC_USER_DEF_ATTRIBUTE7 ,DIST.PJC_USER_DEF_ATTRIBUTE8 ,DIST.PJC_USER_DEF_ATTRIBUTE9 ,DIST.PJC_USER_DEF_ATTRIBUTE10 ,DIST.CREATED_BY ,DIST.CREATION_DATE ,DIST.LAST_UPDATED_BY ,DIST.LAST_UPDATE_DATE ,DIST.LAST_UPDATE_LOGIN ,(NVL(DIST.DISTRIBUTION_QTY, 0) - NVL(DIST.DELIVERED_QTY, 0)) AS "OUTSTANDING_QUANTITY" ,(LINE.UNIT_PRICE * ((NVL(DIST.DISTRIBUTION_QTY, 0)) - (NVL(DIST.DELIVERED_QTY, 0)))) AS "OUTSTANDING_AMOUNT" ,LINE.REQUESTER_ID ,LINE.REQUISITION_ID ,LINE.REQUISITION_LINE_ID ,LINE.LINE_NUMBER ,LINE.LINE_ID ,LINE.INVENTORY_ITEM_ID ,ITEM.ITEM_NUMBER ,ITEM.DESCRIPTION ,LINE.QTY_UOM_CODE ,LINE.CURRENCY_CODE ,LINE.DESTINATION_TYPE_LOOKUP ,LINE.UNIT_PRICE ,HDR.HEADER_NUMBER ,HDR.HEADER_ID ,HDR.REQ_BU_ID ,'Y' AS APPROVED_FLAG ,HDR.SOURCE_TYPE_LOOKUP ,RCS.PROJECT_TYPE_ID ,RCS.COST_COLL_EXCLUDED FROM INV_TRANSFER_ORDER_HEADERS HDR,INV_TRANSFER_ORDER_LINES LINE, INV_TRANSFER_ORDER_DISTRIBS DIST, EGP_SYSTEM_ITEMS_VL ITEM ,RCS_PROJ_COST_COLL_STATUS_V RCS WHERE HDR.HEADER_ID = LINE.HEADER_ID AND LINE.LINE_ID = DIST.LINE_ID AND LINE.DESTINATION_ORGANIZATION_ID = ITEM.ORGANIZATION_ID AND LINE.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID AND DIST.PJC_PROJECT_ID IS NOT NULL AND LINE.STATUS_LOOKUP = 'OPEN' AND DIST.PJC_PROJECT_ID = RCS.PROJECT_ID (+)