VIEW: APPS.CSP_ASL_ITEM_SUB_INVENTORIES_V

Source

View Text - Preformatted

SELECT cis.ROW_ID, cis.ATTRIBUTE1, cis.ATTRIBUTE10, cis.ATTRIBUTE11, cis.ATTRIBUTE12, cis.ATTRIBUTE13, cis.ATTRIBUTE14, cis.ATTRIBUTE15, cis.ATTRIBUTE2, cis.ATTRIBUTE3, cis.ATTRIBUTE4, cis.ATTRIBUTE5, cis.ATTRIBUTE6, cis.ATTRIBUTE7, cis.ATTRIBUTE8, cis.ATTRIBUTE9, cis.ATTRIBUTE_CATEGORY, cis.CONCATENATED_SEGMENTS, cis.CREATED_BY, cis.CREATION_DATE, cis.ENCUMBRANCE_ACCOUNT, cis.FIXED_LOT_MULTIPLE, cis.INVENTORY_ITEM_ID, cis.INVENTORY_PLANNING_CODE, cis.ITEM_DESCRIPTION, cis.LAST_UPDATE_DATE, cis.LAST_UPDATE_LOGIN, cis.LAST_UPDATED_BY, cis.MANUAL_AUTO, cis.MAX_MINMAX_QUANTITY, cis.MAXIMUM_ORDER_QUANTITY, cis.MIN_MINMAX_QUANTITY, cis.MINIMUM_ORDER_QUANTITY, cis.ORGANIZATION_CODE, NVL(cis.ORGANIZATION_ID,-1) AS ORGANIZATION_ID, cis.ORGANIZATION_NAME, cis.PICKING_ORDER, cis.POSTPROCESSING_LEAD_TIME, cis.PREPROCESSING_LEAD_TIME, cis.PRIMARY_SUBINVENTORY_FLAG, cis.PROCESSING_LEAD_TIME, cis.REASON_CODE, cis.REASON_CODE_MEANING, NVL(cis.SECONDARY_INVENTORY,'-') AS SECONDARY_INVENTORY, cis.SOURCE_ORG_NAME, cis.SOURCE_ORGANIZATION, cis.SOURCE_ORGANIZATION_ID, cis.SOURCE_SUBINVENTORY, cis.SOURCE_TYPE, cis.SOURCE_TYPE_NAME, cis.SUB_DESCRIPTION, 'SUBINVENTORY' rec_type from csp_item_sub_inventories_all_v cis,csp_planning_parameters cpp where cpp.node_type = 'SUBINVENTORY' and cpp.organization_id = cis.organization_id and cpp.secondary_inventory = cis.secondary_inventory union all select cai.ROW_ID, cai.ATTRIBUTE1, cai.ATTRIBUTE10, cai.ATTRIBUTE11, cai.ATTRIBUTE12, cai.ATTRIBUTE13, cai.ATTRIBUTE14, cai.ATTRIBUTE15, cai.ATTRIBUTE2, cai.ATTRIBUTE3, cai.ATTRIBUTE4, cai.ATTRIBUTE5, cai.ATRIBUTE6, cai.ATTRIBUTE7, cai.ATTRIBUTE8, cai.ATTRIBUTE9, cai.ATTRIBUTE_CATEGORY, cai.CONCATENATED_SEGMENTS, cai.CREATED_BY, cai.CREATION_DATE, cai.ENCUMBRANCE_ACCOUNT, cai.FIXED_LOT_MULTIPLE, cai.INVENTORY_ITEM_ID, cai.INVENTORY_PLANNING_CODE, cai.ITEM_DESCRIPTION, cai.LAST_UPDATE_DATE, cai.LAST_UPDATE_LOGIN, cai.LAST_UPDATED_BY, cai.MANUAL_AUTO, cai.MAX_MINMAX_QUANTITY, cai.MAXIMUM_ORDER_QUANTITY, cai.MIN_MINMAX_QUANTITY, cai.MINIMUM_ORDER_QUANTITY, ood1.organization_code ORGANIZATION_CODE, NVL(cai.ORGANIZATION_ID,-1) AS ORGANIZATION_ID, cai.ORGANIZATION_NAME, null PICKING_ORDER, cai.POSTPROCESSING_LEAD_TIME, cai.PREPROCESSING_LEAD_TIME, null PRIMARY_SUBINVENTORY_FLAG, null PROCESSING_LEAD_TIME, cai.REASON_CODE, cai.REASON_CODE_MEANING, '-' SECONDARY_INVENTORY, ood.organization_name SOURCE_ORG_NAME, ood.organization_code SOURCE_ORGANIZATION, cai.SOURCE_ORGANIZATION_ID, cai.SOURCE_SUBINVENTORY, cai.SOURCE_TYPE, cai.SOURCE_TYPE_NAME, null SUB_DESCRIPTION, 'ORGANIZATION_WH' rec_type from csp_asl_items_v cai,csp_planning_parameters cpp,org_organization_definitions ood, org_organization_definitions ood1 where cpp.node_type = 'ORGANIZATION_WH' and cai.organization_id = cpp.organization_id and cai.source_organization_id = ood.organization_id(+) AND CAI.ORGANIZATION_ID = OOD1.ORGANIZATION_ID(+)

View Text - HTML Formatted

SELECT CIS.ROW_ID
, CIS.ATTRIBUTE1
, CIS.ATTRIBUTE10
, CIS.ATTRIBUTE11
, CIS.ATTRIBUTE12
, CIS.ATTRIBUTE13
, CIS.ATTRIBUTE14
, CIS.ATTRIBUTE15
, CIS.ATTRIBUTE2
, CIS.ATTRIBUTE3
, CIS.ATTRIBUTE4
, CIS.ATTRIBUTE5
, CIS.ATTRIBUTE6
, CIS.ATTRIBUTE7
, CIS.ATTRIBUTE8
, CIS.ATTRIBUTE9
, CIS.ATTRIBUTE_CATEGORY
, CIS.CONCATENATED_SEGMENTS
, CIS.CREATED_BY
, CIS.CREATION_DATE
, CIS.ENCUMBRANCE_ACCOUNT
, CIS.FIXED_LOT_MULTIPLE
, CIS.INVENTORY_ITEM_ID
, CIS.INVENTORY_PLANNING_CODE
, CIS.ITEM_DESCRIPTION
, CIS.LAST_UPDATE_DATE
, CIS.LAST_UPDATE_LOGIN
, CIS.LAST_UPDATED_BY
, CIS.MANUAL_AUTO
, CIS.MAX_MINMAX_QUANTITY
, CIS.MAXIMUM_ORDER_QUANTITY
, CIS.MIN_MINMAX_QUANTITY
, CIS.MINIMUM_ORDER_QUANTITY
, CIS.ORGANIZATION_CODE
, NVL(CIS.ORGANIZATION_ID
, -1) AS ORGANIZATION_ID
, CIS.ORGANIZATION_NAME
, CIS.PICKING_ORDER
, CIS.POSTPROCESSING_LEAD_TIME
, CIS.PREPROCESSING_LEAD_TIME
, CIS.PRIMARY_SUBINVENTORY_FLAG
, CIS.PROCESSING_LEAD_TIME
, CIS.REASON_CODE
, CIS.REASON_CODE_MEANING
, NVL(CIS.SECONDARY_INVENTORY
, '-') AS SECONDARY_INVENTORY
, CIS.SOURCE_ORG_NAME
, CIS.SOURCE_ORGANIZATION
, CIS.SOURCE_ORGANIZATION_ID
, CIS.SOURCE_SUBINVENTORY
, CIS.SOURCE_TYPE
, CIS.SOURCE_TYPE_NAME
, CIS.SUB_DESCRIPTION
, 'SUBINVENTORY' REC_TYPE
FROM CSP_ITEM_SUB_INVENTORIES_ALL_V CIS
, CSP_PLANNING_PARAMETERS CPP
WHERE CPP.NODE_TYPE = 'SUBINVENTORY'
AND CPP.ORGANIZATION_ID = CIS.ORGANIZATION_ID
AND CPP.SECONDARY_INVENTORY = CIS.SECONDARY_INVENTORY UNION ALL SELECT CAI.ROW_ID
, CAI.ATTRIBUTE1
, CAI.ATTRIBUTE10
, CAI.ATTRIBUTE11
, CAI.ATTRIBUTE12
, CAI.ATTRIBUTE13
, CAI.ATTRIBUTE14
, CAI.ATTRIBUTE15
, CAI.ATTRIBUTE2
, CAI.ATTRIBUTE3
, CAI.ATTRIBUTE4
, CAI.ATTRIBUTE5
, CAI.ATRIBUTE6
, CAI.ATTRIBUTE7
, CAI.ATTRIBUTE8
, CAI.ATTRIBUTE9
, CAI.ATTRIBUTE_CATEGORY
, CAI.CONCATENATED_SEGMENTS
, CAI.CREATED_BY
, CAI.CREATION_DATE
, CAI.ENCUMBRANCE_ACCOUNT
, CAI.FIXED_LOT_MULTIPLE
, CAI.INVENTORY_ITEM_ID
, CAI.INVENTORY_PLANNING_CODE
, CAI.ITEM_DESCRIPTION
, CAI.LAST_UPDATE_DATE
, CAI.LAST_UPDATE_LOGIN
, CAI.LAST_UPDATED_BY
, CAI.MANUAL_AUTO
, CAI.MAX_MINMAX_QUANTITY
, CAI.MAXIMUM_ORDER_QUANTITY
, CAI.MIN_MINMAX_QUANTITY
, CAI.MINIMUM_ORDER_QUANTITY
, OOD1.ORGANIZATION_CODE ORGANIZATION_CODE
, NVL(CAI.ORGANIZATION_ID
, -1) AS ORGANIZATION_ID
, CAI.ORGANIZATION_NAME
, NULL PICKING_ORDER
, CAI.POSTPROCESSING_LEAD_TIME
, CAI.PREPROCESSING_LEAD_TIME
, NULL PRIMARY_SUBINVENTORY_FLAG
, NULL PROCESSING_LEAD_TIME
, CAI.REASON_CODE
, CAI.REASON_CODE_MEANING
, '-' SECONDARY_INVENTORY
, OOD.ORGANIZATION_NAME SOURCE_ORG_NAME
, OOD.ORGANIZATION_CODE SOURCE_ORGANIZATION
, CAI.SOURCE_ORGANIZATION_ID
, CAI.SOURCE_SUBINVENTORY
, CAI.SOURCE_TYPE
, CAI.SOURCE_TYPE_NAME
, NULL SUB_DESCRIPTION
, 'ORGANIZATION_WH' REC_TYPE
FROM CSP_ASL_ITEMS_V CAI
, CSP_PLANNING_PARAMETERS CPP
, ORG_ORGANIZATION_DEFINITIONS OOD
, ORG_ORGANIZATION_DEFINITIONS OOD1
WHERE CPP.NODE_TYPE = 'ORGANIZATION_WH'
AND CAI.ORGANIZATION_ID = CPP.ORGANIZATION_ID
AND CAI.SOURCE_ORGANIZATION_ID = OOD.ORGANIZATION_ID(+)
AND CAI.ORGANIZATION_ID = OOD1.ORGANIZATION_ID(+)