CMF_FD_INV_ORG_INT_OTBI_V

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name
FD_HEADERS_INT_ID FD_LINES_INT_ID SRC_INVENTORY_ORG_ID DEST_INVENTORY_ORG_ID SOURCE_DOCUMENT_TYPE

Query

SQL_Statement

SELECT FDL.FD_HEADERS_INT_ID ,FDL.FD_LINES_INT_ID ,NULL SRC_INVENTORY_ORG_ID ,PLL.SHIP_TO_ORGANIZATION_ID DEST_INVENTORY_ORG_ID ,FDL.SOURCE_DOCUMENT_TYPE FROM PO_LINE_LOCATIONS_ALL PLL ,CMF_FD_LINES_INT FDL WHERE PLL.LINE_LOCATION_ID(+) = FDL.SOURCE_DOC_SCHEDULE_ID AND FDL.SOURCE_DOCUMENT_TYPE = 'PURCHASE_ORDER' UNION SELECT FDL.FD_HEADERS_INT_ID ,FDL.FD_LINES_INT_ID ,RSH.ORGANIZATION_ID SRC_INVENTORY_ORG_ID ,RSH.SHIP_TO_ORG_ID DEST_INVENTORY_ORG_ID ,FDL.SOURCE_DOCUMENT_TYPE FROM RCV_SHIPMENT_HEADERS RSH ,CMF_FD_LINES_INT FDL WHERE RSH.SHIPMENT_HEADER_ID(+) = FDL.SOURCE_DOC_HEADER_ID AND FDL.SOURCE_DOCUMENT_TYPE = 'INTERNAL_REQUISITION' UNION SELECT FDL.FD_HEADERS_INT_ID ,FDL.FD_LINES_INT_ID ,NULL SRC_INVENTORY_ORG_ID ,DOFLV.FULFILL_ORG_ID DEST_INVENTORY_ORG_ID ,FDL.SOURCE_DOCUMENT_TYPE FROM DOO_FULFILL_LINES_ALL_V DOFLV ,CMF_FD_LINES_INT FDL WHERE DOFLV.FULFILL_LINE_ID(+) = FDL.SOURCE_DOC_SCHEDULE_ID AND FDL.SOURCE_DOCUMENT_TYPE = 'RETURN_MATERIAL_AUTHORIZATION' UNION SELECT FDL.FD_HEADERS_INT_ID ,FDL.FD_LINES_INT_ID ,NULL SRC_INVENTORY_ORG_ID ,IOD.ORGANIZATION_ID DEST_INVENTORY_ORG_ID ,FDL.SOURCE_DOCUMENT_TYPE FROM RCS_ORG_DEFINITIONS_LW_V IOD ,EGP_SYSTEM_ITEMS_VL EGP ,CMF_FD_LINES_INT FDL WHERE IOD.ORGANIZATION_ID = IOD.MASTER_ORGANIZATION_ID AND IOD.ORGANIZATION_ID = EGP.ORGANIZATION_ID AND EGP.PURCHASING_ITEM_FLAG(+) = 'Y' AND EGP.INVENTORY_ITEM_ID(+) = FDL.ITEM_ID AND FDL.SOURCE_DOCUMENT_TYPE = 'NO_SOURCE'