CMF_FISCAL_DOC_INV_ORG_V

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name
FISCAL_DOC_HEADER_ID FISCAL_DOC_LINE_ID SRC_INVENTORY_ORG_ID DEST_INVENTORY_ORG_ID SOURCE_DOC_TYPE

Query

SQL_Statement

SELECT DISTINCT FDS.FISCAL_DOC_HEADER_ID, FDS.FISCAL_DOC_LINE_ID, NULL SRC_INVENTORY_ORG_ID, PLL.SHIP_TO_ORGANIZATION_ID DEST_INVENTORY_ORG_ID, FDS.SOURCE_DOC_TYPE FROM PO_LINE_LOCATIONS_ALL PLL ,CMF_FISCAL_DOC_SCHEDULES FDS WHERE PLL.LINE_LOCATION_ID(+) = FDS.SOURCE_DOC_ID3 AND FDS.SOURCE_DOC_TYPE = 'PURCHASE_ORDER' UNION SELECT DISTINCT FDS.FISCAL_DOC_HEADER_ID, FDS.FISCAL_DOC_LINE_ID, RSH.ORGANIZATION_ID SRC_INVENTORY_ORG_ID, RSH.SHIP_TO_ORG_ID DEST_INVENTORY_ORG_ID, FDS.SOURCE_DOC_TYPE FROM RCV_SHIPMENT_HEADERS RSH ,CMF_FISCAL_DOC_SCHEDULES FDS WHERE RSH.SHIPMENT_HEADER_ID(+) = FDS.SOURCE_DOC_ID1 AND FDS.SOURCE_DOC_TYPE = 'INTERNAL_REQUISITION' UNION SELECT DISTINCT FDS.FISCAL_DOC_HEADER_ID, FDS.FISCAL_DOC_LINE_ID, NULL SRC_INVENTORY_ORG_ID, DOFLV.FULFILL_ORG_ID DEST_INVENTORY_ORG_ID, FDS.SOURCE_DOC_TYPE FROM DOO_FULFILL_LINES_ALL_V DOFLV ,CMF_FISCAL_DOC_SCHEDULES FDS WHERE DOFLV.FULFILL_LINE_ID(+) = FDS.SOURCE_DOC_ID3 AND FDS.SOURCE_DOC_TYPE = 'RETURN_MATERIAL_AUTHORIZATION' UNION SELECT FDL.DOCUMENT_HEADER_ID FISCAL_DOC_HEADER_ID, FDL.DOCUMENT_LINE_ID FISCAL_DOC_LINE_ID, NULL SRC_INVENTORY_ORG_ID, IOD.ORGANIZATION_ID DEST_INVENTORY_ORG_ID, FDL.SOURCE_DOCUMENT_TYPE SOURCE_DOC_TYPE FROM RCS_ORG_DEFINITIONS_LW_V IOD ,EGP_SYSTEM_ITEMS_VL EGP ,CMF_FISCAL_DOC_LINES_B 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'