VIEW: APPS.MTL_KANBAN_PULL_SEQUENCES_V

Source

View Text - Preformatted

SELECT MKP.PULL_SEQUENCE_ID, MKP.ORGANIZATION_ID, MKP.KANBAN_PLAN_ID, MKP.INVENTORY_ITEM_ID, MKP.SUBINVENTORY_NAME, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE, MKP.LOCATOR_ID, MKP.SOURCE_TYPE, MLK.MEANING SOURCE_TYPE_MEANING, MKP.LAST_UPDATE_DATE, MKP.LAST_UPDATED_BY, MKP.CREATION_DATE, MKP.CREATED_BY , MKP.SUPPLIER_ID, NULL SUPPLIER_NAME, MKP.SUPPLIER_SITE_ID, MKP.SOURCE_ORGANIZATION_ID, to_char(MSI.LOCATION_CONTROL_CODE) SOURCE_ITEM_LOC_CONTROL, to_char(MSI.RESTRICT_SUBINVENTORIES_CODE) SOURCE_ITEM_RESTRICT_SUB, to_char(MSI.RESTRICT_LOCATORS_CODE) SOURCE_ITEM_RESTRICT_LOC, TO_CHAR(MTP.STOCK_LOCATOR_CONTROL_CODE)SOURCE_ORG_LOCATOR_CONTROL, TO_CHAR(MTP.NEGATIVE_INV_RECEIPT_CODE) SOURCE_ORG_NEGATIVE_CONTROL, MTP.ORGANIZATION_CODE SOURCE_ORG_CODE, HOU.NAME SOURCE_ORG_NAME, MKP.SOURCE_SUBINVENTORY , to_char(MSS2.LOCATOR_TYPE) SOURCE_SUB_LOCATOR_TYPE, MKP.SOURCE_LOCATOR_ID, MKP.WIP_LINE_ID , NULL WIP_LINE_CODE, MKP.REPLENISHMENT_LEAD_TIME, MKP.CALCULATE_KANBAN_FLAG, MKP.KANBAN_SIZE, MKP.FIXED_LOT_MULTIPLIER, MKP.SAFETY_STOCK_DAYS, MKP.NUMBER_OF_CARDS, MKP.MINIMUM_ORDER_QUANTITY, MKP.AGGREGATION_TYPE, MKP.ALLOCATION_PERCENT, MKP.LAST_UPDATE_LOGIN, MKP.UPDATED_FLAG, MKP.RELEASE_KANBAN_FLAG, MKP.ATTRIBUTE_CATEGORY, MKP.ATTRIBUTE1, MKP.ATTRIBUTE2, MKP.ATTRIBUTE3, MKP.ATTRIBUTE4, MKP.ATTRIBUTE5, MKP.ATTRIBUTE6, MKP.ATTRIBUTE7, MKP.ATTRIBUTE8, MKP.ATTRIBUTE9, MKP.ATTRIBUTE10, MKP.ATTRIBUTE11, MKP.ATTRIBUTE12, MKP.ATTRIBUTE13, MKP.ATTRIBUTE14, MKP.ATTRIBUTE15, MKP.REQUEST_ID, MKP.PROGRAM_APPLICATION_ID, MKP.PROGRAM_ID , MKP.PROGRAM_UPDATE_DATE, NVL(MKP.AUTO_REQUEST,'N') AUTO_REQUEST, MKP.AUTO_ALLOCATE_FLAG FROM MTL_SYSTEM_ITEMS MSI, MTL_SECONDARY_INVENTORIES MSS, MTL_SECONDARY_INVENTORIES MSS2, HR_ORGANIZATION_UNITS HOU, MTL_PARAMETERS MTP, MTL_KANBAN_PULL_SEQUENCES MKP, MFG_LOOKUPS MLK WHERE MLK.LOOKUP_CODE IN (1,3) AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE' AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MKP.SOURCE_ORGANIZATION_ID IS NOT NULL AND MTP.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID AND MSS2.SECONDARY_INVENTORY_NAME = MKP.SOURCE_SUBINVENTORY AND MSS2.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID AND MSI.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKP.INVENTORY_ITEM_ID AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) AND (MSS2.SUBINVENTORY_TYPE = 1 OR MSS2.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKP.PULL_SEQUENCE_ID, MKP.ORGANIZATION_ID, MKP.KANBAN_PLAN_ID , MKP.INVENTORY_ITEM_ID, MKP.SUBINVENTORY_NAME, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE, MKP.LOCATOR_ID, MKP.SOURCE_TYPE, MLK.MEANING SOURCE_TYPE_MEANING, MKP.LAST_UPDATE_DATE, MKP.LAST_UPDATED_BY, MKP.CREATION_DATE, MKP.CREATED_BY , MKP.SUPPLIER_ID, NULL SUPPLIER_NAME, MKP.SUPPLIER_SITE_ID, MKP.SOURCE_ORGANIZATION_ID, NULL SOURCE_ITEM_LOC_CONTROL, NULL SOURCE_ITEM_RESTRICT_SUB, NULL SOURCE_ITEM_RESTRICT_LOC, NULL SOURCE_ORG_LOCATOR_CONTROL, NULL SOURCE_ORG_NEGATIVE_CONTROL, NULL SOURCE_ORG_CODE, NULL SOURCE_ORG_NAME, MKP.SOURCE_SUBINVENTORY , NULL SOURCE_SUB_LOCATOR_TYPE, MKP.SOURCE_LOCATOR_ID, MKP.WIP_LINE_ID , NULL WIP_LINE_CODE, MKP.REPLENISHMENT_LEAD_TIME, MKP.CALCULATE_KANBAN_FLAG, MKP.KANBAN_SIZE, MKP.FIXED_LOT_MULTIPLIER, MKP.SAFETY_STOCK_DAYS, MKP.NUMBER_OF_CARDS, MKP.MINIMUM_ORDER_QUANTITY, MKP.AGGREGATION_TYPE, MKP.ALLOCATION_PERCENT, MKP.LAST_UPDATE_LOGIN, MKP.UPDATED_FLAG, MKP.RELEASE_KANBAN_FLAG, MKP.ATTRIBUTE_CATEGORY, MKP.ATTRIBUTE1, MKP.ATTRIBUTE2, MKP.ATTRIBUTE3, MKP.ATTRIBUTE4, MKP.ATTRIBUTE5, MKP.ATTRIBUTE6, MKP.ATTRIBUTE7, MKP.ATTRIBUTE8, MKP.ATTRIBUTE9, MKP.ATTRIBUTE10, MKP.ATTRIBUTE11, MKP.ATTRIBUTE12, MKP.ATTRIBUTE13, MKP.ATTRIBUTE14, MKP.ATTRIBUTE15, MKP.REQUEST_ID, MKP.PROGRAM_APPLICATION_ID, MKP.PROGRAM_ID , MKP.PROGRAM_UPDATE_DATE, NVL( MKP.AUTO_REQUEST,'N') AUTO_REQUEST, MKP.AUTO_ALLOCATE_FLAG FROM MTL_SECONDARY_INVENTORIES MSS, MTL_KANBAN_PULL_SEQUENCES MKP, MFG_LOOKUPS MLK WHERE MLK.LOOKUP_CODE IN (1,3) AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE' AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MKP.SOURCE_ORGANIZATION_ID IS NULL AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL select MKP.PULL_SEQUENCE_ID, MKP.ORGANIZATION_ID, MKP.KANBAN_PLAN_ID , MKP.INVENTORY_ITEM_ID, MKP.SUBINVENTORY_NAME, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE, MKP.LOCATOR_ID, MKP.SOURCE_TYPE, MLK.MEANING SOURCE_TYPE_MEANING, MKP.LAST_UPDATE_DATE, MKP.LAST_UPDATED_BY, MKP.CREATION_DATE, MKP.CREATED_BY , MKP.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKP.SUPPLIER_SITE_ID, MKP.SOURCE_ORGANIZATION_ID, NULL SOURCE_ITEM_LOC_CONTROL, NULL SOURCE_ORG_RESTRICT_SUB, NULL SOURCE_ORG_RESTRICT_LOC, NULL SOURCE_ORG_LOCATOR_CONTROL, NULL SOURCE_ORG_NEGATIVE_CONTROL, NULL SOURCE_ORG_CODE, NULL SOURCE_ORG_NAME, MKP.SOURCE_SUBINVENTORY , NULL SOURCE_SUB_LOCATOR_TYPE, MKP.SOURCE_LOCATOR_ID, MKP.WIP_LINE_ID , NULL WIP_LINE_CODE, MKP.REPLENISHMENT_LEAD_TIME, MKP.CALCULATE_KANBAN_FLAG, MKP.KANBAN_SIZE, MKP.FIXED_LOT_MULTIPLIER, MKP.SAFETY_STOCK_DAYS, MKP.NUMBER_OF_CARDS, MKP.MINIMUM_ORDER_QUANTITY, MKP.AGGREGATION_TYPE, MKP.ALLOCATION_PERCENT, MKP.LAST_UPDATE_LOGIN, MKP.UPDATED_FLAG, MKP.RELEASE_KANBAN_FLAG, MKP.ATTRIBUTE_CATEGORY, MKP.ATTRIBUTE1, MKP.ATTRIBUTE2, MKP.ATTRIBUTE3, MKP.ATTRIBUTE4, MKP.ATTRIBUTE5, MKP.ATTRIBUTE6, MKP.ATTRIBUTE7, MKP.ATTRIBUTE8, MKP.ATTRIBUTE9, MKP.ATTRIBUTE10, MKP.ATTRIBUTE11, MKP.ATTRIBUTE12, MKP.ATTRIBUTE13, MKP.ATTRIBUTE14, MKP.ATTRIBUTE15, MKP.REQUEST_ID, MKP.PROGRAM_APPLICATION_ID, MKP.PROGRAM_ID , MKP.PROGRAM_UPDATE_DATE, NVL(MKP.AUTO_REQUEST,'N') AUTO_REQUEST, MKP.AUTO_ALLOCATE_FLAG FROM PO_VENDORS POV, MTL_SECONDARY_INVENTORIES MSS, MTL_KANBAN_PULL_SEQUENCES MKP, MFG_LOOKUPS MLK WHERE MLK.LOOKUP_CODE = 2 AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE' AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE AND MKP.SUPPLIER_ID = POV.VENDOR_ID AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MKP.SUPPLIER_ID IS NOT NULL AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL select MKP.PULL_SEQUENCE_ID, MKP.ORGANIZATION_ID, MKP.KANBAN_PLAN_ID , MKP.INVENTORY_ITEM_ID, MKP.SUBINVENTORY_NAME, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE, MKP.LOCATOR_ID, MKP.SOURCE_TYPE, MLK.MEANING SOURCE_TYPE_MEANING, MKP.LAST_UPDATE_DATE, MKP.LAST_UPDATED_BY, MKP.CREATION_DATE, MKP.CREATED_BY , MKP.SUPPLIER_ID, NULL SUPPLIER_NAME, MKP.SUPPLIER_SITE_ID, MKP.SOURCE_ORGANIZATION_ID, NULL SOURCE_ITEM_LOC_CONTROL, NULL SOURCE_ITEM_RESTRICT_SUB, NULL SOURCE_ITEM_RESTRICT_LOC, NULL SOURCE_ORG_LOCATOR_CONTROL, NULL SOURCE_ORG_NEGATIVE_CONTROL, NULL SOURCE_ORG_CODE, NULL SOURCE_ORG_NAME, MKP.SOURCE_SUBINVENTORY , NULL SOURCE_SUB_LOCATOR_TYPE, MKP.SOURCE_LOCATOR_ID, MKP.WIP_LINE_ID , NULL WIP_LINE_CODE, MKP.REPLENISHMENT_LEAD_TIME, MKP.CALCULATE_KANBAN_FLAG, MKP.KANBAN_SIZE, MKP.FIXED_LOT_MULTIPLIER, MKP.SAFETY_STOCK_DAYS, MKP.NUMBER_OF_CARDS, MKP.MINIMUM_ORDER_QUANTITY, MKP.AGGREGATION_TYPE, MKP.ALLOCATION_PERCENT, MKP.LAST_UPDATE_LOGIN, MKP.UPDATED_FLAG, MKP.RELEASE_KANBAN_FLAG, MKP.ATTRIBUTE_CATEGORY, MKP.ATTRIBUTE1, MKP.ATTRIBUTE2, MKP.ATTRIBUTE3, MKP.ATTRIBUTE4, MKP.ATTRIBUTE5, MKP.ATTRIBUTE6, MKP.ATTRIBUTE7, MKP.ATTRIBUTE8, MKP.ATTRIBUTE9, MKP.ATTRIBUTE10, MKP.ATTRIBUTE11, MKP.ATTRIBUTE12, MKP.ATTRIBUTE13, MKP.ATTRIBUTE14, MKP.ATTRIBUTE15, MKP.REQUEST_ID, MKP.PROGRAM_APPLICATION_ID, MKP.PROGRAM_ID , MKP.PROGRAM_UPDATE_DATE, NVL(MKP.AUTO_REQUEST,'N') AUTO_REQUEST, MKP.AUTO_ALLOCATE_FLAG FROM MTL_SECONDARY_INVENTORIES MSS, MTL_KANBAN_PULL_SEQUENCES MKP, MFG_LOOKUPS MLK WHERE MLK.LOOKUP_CODE = 2 AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE' AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MKP.SUPPLIER_ID IS NULL AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL select MKP.PULL_SEQUENCE_ID, MKP.ORGANIZATION_ID, MKP.KANBAN_PLAN_ID , MKP.INVENTORY_ITEM_ID, MKP.SUBINVENTORY_NAME, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE, MKP.LOCATOR_ID, MKP.SOURCE_TYPE, MLK.MEANING SOURCE_TYPE_MEANING, MKP.LAST_UPDATE_DATE, MKP.LAST_UPDATED_BY, MKP.CREATION_DATE, MKP.CREATED_BY , MKP.SUPPLIER_ID, NULL SUPPLIER_NAME, MKP.SUPPLIER_SITE_ID, MKP.SOURCE_ORGANIZATION_ID, NULL SOURCE_ITEM_LOC_CONTROL, NULL SOURCE_ITEM_RESTRICT_SUB, NULL SOURCE_ITEM_RESTRICT_LOC, NULL SOURCE_ORG_LOCATOR_CONTROL, NULL SOURCE_ORG_NEGATIVE_CONTROL, NULL SOURCE_ORG_CODE, NULL SOURCE_ORG_NAME, MKP.SOURCE_SUBINVENTORY , NULL SOURCE_SUB_LOCATOR_TYPE, MKP.SOURCE_LOCATOR_ID, MKP.WIP_LINE_ID , WIP.LINE_CODE WIP_LINE_CODE, MKP.REPLENISHMENT_LEAD_TIME, MKP.CALCULATE_KANBAN_FLAG, MKP.KANBAN_SIZE, MKP.FIXED_LOT_MULTIPLIER, MKP.SAFETY_STOCK_DAYS, MKP.NUMBER_OF_CARDS, MKP.MINIMUM_ORDER_QUANTITY, MKP.AGGREGATION_TYPE, MKP.ALLOCATION_PERCENT, MKP.LAST_UPDATE_LOGIN, MKP.UPDATED_FLAG, MKP.RELEASE_KANBAN_FLAG, MKP.ATTRIBUTE_CATEGORY, MKP.ATTRIBUTE1, MKP.ATTRIBUTE2, MKP.ATTRIBUTE3, MKP.ATTRIBUTE4, MKP.ATTRIBUTE5, MKP.ATTRIBUTE6, MKP.ATTRIBUTE7, MKP.ATTRIBUTE8, MKP.ATTRIBUTE9, MKP.ATTRIBUTE10, MKP.ATTRIBUTE11, MKP.ATTRIBUTE12, MKP.ATTRIBUTE13, MKP.ATTRIBUTE14, MKP.ATTRIBUTE15, MKP.REQUEST_ID, MKP.PROGRAM_APPLICATION_ID, MKP.PROGRAM_ID , MKP.PROGRAM_UPDATE_DATE, NVL(MKP.AUTO_REQUEST,'N') AUTO_REQUEST, MKP.AUTO_ALLOCATE_FLAG FROM WIP_LINES WIP, MTL_SECONDARY_INVENTORIES MSS, MTL_KANBAN_PULL_SEQUENCES MKP, MFG_LOOKUPS MLK WHERE MLK.LOOKUP_CODE = 4 AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE' AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE AND WIP.LINE_ID = MKP.WIP_LINE_ID AND WIP.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MKP.WIP_LINE_ID IS NOT NULL AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL select MKP.PULL_SEQUENCE_ID, MKP.ORGANIZATION_ID, MKP.KANBAN_PLAN_ID , MKP.INVENTORY_ITEM_ID, MKP.SUBINVENTORY_NAME, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE, MKP.LOCATOR_ID, MKP.SOURCE_TYPE, MLK.MEANING SOURCE_TYPE_MEANING, MKP.LAST_UPDATE_DATE, MKP.LAST_UPDATED_BY, MKP.CREATION_DATE, MKP.CREATED_BY , MKP.SUPPLIER_ID, NULL SUPPLIER_NAME, MKP.SUPPLIER_SITE_ID, MKP.SOURCE_ORGANIZATION_ID, NULL SOURCE_ITEM_LOC_CONTROL, NULL SOURCE_ITEM_RESTRICT_SUB, NULL SOURCE_ITEM_RESTRICT_LOC, NULL SOURCE_ORG_LOCATOR_CONTROL, NULL SOURCE_ORG_NEGATIVE_CONTROL, NULL SOURCE_ORG_CODE, NULL SOURCE_ORG_NAME, MKP.SOURCE_SUBINVENTORY , NULL SOURCE_SUB_LOCATOR_TYPE, MKP.SOURCE_LOCATOR_ID, MKP.WIP_LINE_ID, NULL WIP_LINE_CODE, MKP.REPLENISHMENT_LEAD_TIME, MKP.CALCULATE_KANBAN_FLAG, MKP.KANBAN_SIZE, MKP.FIXED_LOT_MULTIPLIER, MKP.SAFETY_STOCK_DAYS, MKP.NUMBER_OF_CARDS, MKP.MINIMUM_ORDER_QUANTITY, MKP.AGGREGATION_TYPE, MKP.ALLOCATION_PERCENT, MKP.LAST_UPDATE_LOGIN, MKP.UPDATED_FLAG, MKP.RELEASE_KANBAN_FLAG, MKP.ATTRIBUTE_CATEGORY, MKP.ATTRIBUTE1, MKP.ATTRIBUTE2, MKP.ATTRIBUTE3, MKP.ATTRIBUTE4, MKP.ATTRIBUTE5, MKP.ATTRIBUTE6, MKP.ATTRIBUTE7, MKP.ATTRIBUTE8, MKP.ATTRIBUTE9, MKP.ATTRIBUTE10, MKP.ATTRIBUTE11, MKP.ATTRIBUTE12, MKP.ATTRIBUTE13, MKP.ATTRIBUTE14, MKP.ATTRIBUTE15, MKP.REQUEST_ID, MKP.PROGRAM_APPLICATION_ID, MKP.PROGRAM_ID , MKP.PROGRAM_UPDATE_DATE, NVL(MKP.AUTO_REQUEST,'N') AUTO_REQUEST, MKP.AUTO_ALLOCATE_FLAG FROM MTL_SECONDARY_INVENTORIES MSS, MTL_KANBAN_PULL_SEQUENCES MKP, MFG_LOOKUPS MLK WHERE MLK.LOOKUP_CODE = 4 AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE' AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MKP.WIP_LINE_ID IS NULL AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL)

View Text - HTML Formatted

SELECT MKP.PULL_SEQUENCE_ID
, MKP.ORGANIZATION_ID
, MKP.KANBAN_PLAN_ID
, MKP.INVENTORY_ITEM_ID
, MKP.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKP.LOCATOR_ID
, MKP.SOURCE_TYPE
, MLK.MEANING SOURCE_TYPE_MEANING
, MKP.LAST_UPDATE_DATE
, MKP.LAST_UPDATED_BY
, MKP.CREATION_DATE
, MKP.CREATED_BY
, MKP.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, MKP.SOURCE_ORGANIZATION_ID
, TO_CHAR(MSI.LOCATION_CONTROL_CODE) SOURCE_ITEM_LOC_CONTROL
, TO_CHAR(MSI.RESTRICT_SUBINVENTORIES_CODE) SOURCE_ITEM_RESTRICT_SUB
, TO_CHAR(MSI.RESTRICT_LOCATORS_CODE) SOURCE_ITEM_RESTRICT_LOC
, TO_CHAR(MTP.STOCK_LOCATOR_CONTROL_CODE)SOURCE_ORG_LOCATOR_CONTROL
, TO_CHAR(MTP.NEGATIVE_INV_RECEIPT_CODE) SOURCE_ORG_NEGATIVE_CONTROL
, MTP.ORGANIZATION_CODE SOURCE_ORG_CODE
, HOU.NAME SOURCE_ORG_NAME
, MKP.SOURCE_SUBINVENTORY
, TO_CHAR(MSS2.LOCATOR_TYPE) SOURCE_SUB_LOCATOR_TYPE
, MKP.SOURCE_LOCATOR_ID
, MKP.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, MKP.CALCULATE_KANBAN_FLAG
, MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.AGGREGATION_TYPE
, MKP.ALLOCATION_PERCENT
, MKP.LAST_UPDATE_LOGIN
, MKP.UPDATED_FLAG
, MKP.RELEASE_KANBAN_FLAG
, MKP.ATTRIBUTE_CATEGORY
, MKP.ATTRIBUTE1
, MKP.ATTRIBUTE2
, MKP.ATTRIBUTE3
, MKP.ATTRIBUTE4
, MKP.ATTRIBUTE5
, MKP.ATTRIBUTE6
, MKP.ATTRIBUTE7
, MKP.ATTRIBUTE8
, MKP.ATTRIBUTE9
, MKP.ATTRIBUTE10
, MKP.ATTRIBUTE11
, MKP.ATTRIBUTE12
, MKP.ATTRIBUTE13
, MKP.ATTRIBUTE14
, MKP.ATTRIBUTE15
, MKP.REQUEST_ID
, MKP.PROGRAM_APPLICATION_ID
, MKP.PROGRAM_ID
, MKP.PROGRAM_UPDATE_DATE
, NVL(MKP.AUTO_REQUEST
, 'N') AUTO_REQUEST
, MKP.AUTO_ALLOCATE_FLAG
FROM MTL_SYSTEM_ITEMS MSI
, MTL_SECONDARY_INVENTORIES MSS
, MTL_SECONDARY_INVENTORIES MSS2
, HR_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS MTP
, MTL_KANBAN_PULL_SEQUENCES MKP
, MFG_LOOKUPS MLK
WHERE MLK.LOOKUP_CODE IN (1
, 3)
AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE
AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID
AND MKP.SOURCE_ORGANIZATION_ID IS NOT NULL
AND MTP.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID
AND MSS2.SECONDARY_INVENTORY_NAME = MKP.SOURCE_SUBINVENTORY
AND MSS2.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MKP.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKP.INVENTORY_ITEM_ID
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL)
AND (MSS2.SUBINVENTORY_TYPE = 1 OR MSS2.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKP.PULL_SEQUENCE_ID
, MKP.ORGANIZATION_ID
, MKP.KANBAN_PLAN_ID
, MKP.INVENTORY_ITEM_ID
, MKP.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKP.LOCATOR_ID
, MKP.SOURCE_TYPE
, MLK.MEANING SOURCE_TYPE_MEANING
, MKP.LAST_UPDATE_DATE
, MKP.LAST_UPDATED_BY
, MKP.CREATION_DATE
, MKP.CREATED_BY
, MKP.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, MKP.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ITEM_LOC_CONTROL
, NULL SOURCE_ITEM_RESTRICT_SUB
, NULL SOURCE_ITEM_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKP.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKP.SOURCE_LOCATOR_ID
, MKP.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, MKP.CALCULATE_KANBAN_FLAG
, MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.AGGREGATION_TYPE
, MKP.ALLOCATION_PERCENT
, MKP.LAST_UPDATE_LOGIN
, MKP.UPDATED_FLAG
, MKP.RELEASE_KANBAN_FLAG
, MKP.ATTRIBUTE_CATEGORY
, MKP.ATTRIBUTE1
, MKP.ATTRIBUTE2
, MKP.ATTRIBUTE3
, MKP.ATTRIBUTE4
, MKP.ATTRIBUTE5
, MKP.ATTRIBUTE6
, MKP.ATTRIBUTE7
, MKP.ATTRIBUTE8
, MKP.ATTRIBUTE9
, MKP.ATTRIBUTE10
, MKP.ATTRIBUTE11
, MKP.ATTRIBUTE12
, MKP.ATTRIBUTE13
, MKP.ATTRIBUTE14
, MKP.ATTRIBUTE15
, MKP.REQUEST_ID
, MKP.PROGRAM_APPLICATION_ID
, MKP.PROGRAM_ID
, MKP.PROGRAM_UPDATE_DATE
, NVL( MKP.AUTO_REQUEST
, 'N') AUTO_REQUEST
, MKP.AUTO_ALLOCATE_FLAG
FROM MTL_SECONDARY_INVENTORIES MSS
, MTL_KANBAN_PULL_SEQUENCES MKP
, MFG_LOOKUPS MLK
WHERE MLK.LOOKUP_CODE IN (1
, 3)
AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE
AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID
AND MKP.SOURCE_ORGANIZATION_ID IS NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKP.PULL_SEQUENCE_ID
, MKP.ORGANIZATION_ID
, MKP.KANBAN_PLAN_ID
, MKP.INVENTORY_ITEM_ID
, MKP.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKP.LOCATOR_ID
, MKP.SOURCE_TYPE
, MLK.MEANING SOURCE_TYPE_MEANING
, MKP.LAST_UPDATE_DATE
, MKP.LAST_UPDATED_BY
, MKP.CREATION_DATE
, MKP.CREATED_BY
, MKP.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, MKP.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ITEM_LOC_CONTROL
, NULL SOURCE_ORG_RESTRICT_SUB
, NULL SOURCE_ORG_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKP.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKP.SOURCE_LOCATOR_ID
, MKP.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, MKP.CALCULATE_KANBAN_FLAG
, MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.AGGREGATION_TYPE
, MKP.ALLOCATION_PERCENT
, MKP.LAST_UPDATE_LOGIN
, MKP.UPDATED_FLAG
, MKP.RELEASE_KANBAN_FLAG
, MKP.ATTRIBUTE_CATEGORY
, MKP.ATTRIBUTE1
, MKP.ATTRIBUTE2
, MKP.ATTRIBUTE3
, MKP.ATTRIBUTE4
, MKP.ATTRIBUTE5
, MKP.ATTRIBUTE6
, MKP.ATTRIBUTE7
, MKP.ATTRIBUTE8
, MKP.ATTRIBUTE9
, MKP.ATTRIBUTE10
, MKP.ATTRIBUTE11
, MKP.ATTRIBUTE12
, MKP.ATTRIBUTE13
, MKP.ATTRIBUTE14
, MKP.ATTRIBUTE15
, MKP.REQUEST_ID
, MKP.PROGRAM_APPLICATION_ID
, MKP.PROGRAM_ID
, MKP.PROGRAM_UPDATE_DATE
, NVL(MKP.AUTO_REQUEST
, 'N') AUTO_REQUEST
, MKP.AUTO_ALLOCATE_FLAG
FROM PO_VENDORS POV
, MTL_SECONDARY_INVENTORIES MSS
, MTL_KANBAN_PULL_SEQUENCES MKP
, MFG_LOOKUPS MLK
WHERE MLK.LOOKUP_CODE = 2
AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE
AND MKP.SUPPLIER_ID = POV.VENDOR_ID
AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID
AND MKP.SUPPLIER_ID IS NOT NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKP.PULL_SEQUENCE_ID
, MKP.ORGANIZATION_ID
, MKP.KANBAN_PLAN_ID
, MKP.INVENTORY_ITEM_ID
, MKP.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKP.LOCATOR_ID
, MKP.SOURCE_TYPE
, MLK.MEANING SOURCE_TYPE_MEANING
, MKP.LAST_UPDATE_DATE
, MKP.LAST_UPDATED_BY
, MKP.CREATION_DATE
, MKP.CREATED_BY
, MKP.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, MKP.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ITEM_LOC_CONTROL
, NULL SOURCE_ITEM_RESTRICT_SUB
, NULL SOURCE_ITEM_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKP.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKP.SOURCE_LOCATOR_ID
, MKP.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, MKP.CALCULATE_KANBAN_FLAG
, MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.AGGREGATION_TYPE
, MKP.ALLOCATION_PERCENT
, MKP.LAST_UPDATE_LOGIN
, MKP.UPDATED_FLAG
, MKP.RELEASE_KANBAN_FLAG
, MKP.ATTRIBUTE_CATEGORY
, MKP.ATTRIBUTE1
, MKP.ATTRIBUTE2
, MKP.ATTRIBUTE3
, MKP.ATTRIBUTE4
, MKP.ATTRIBUTE5
, MKP.ATTRIBUTE6
, MKP.ATTRIBUTE7
, MKP.ATTRIBUTE8
, MKP.ATTRIBUTE9
, MKP.ATTRIBUTE10
, MKP.ATTRIBUTE11
, MKP.ATTRIBUTE12
, MKP.ATTRIBUTE13
, MKP.ATTRIBUTE14
, MKP.ATTRIBUTE15
, MKP.REQUEST_ID
, MKP.PROGRAM_APPLICATION_ID
, MKP.PROGRAM_ID
, MKP.PROGRAM_UPDATE_DATE
, NVL(MKP.AUTO_REQUEST
, 'N') AUTO_REQUEST
, MKP.AUTO_ALLOCATE_FLAG
FROM MTL_SECONDARY_INVENTORIES MSS
, MTL_KANBAN_PULL_SEQUENCES MKP
, MFG_LOOKUPS MLK
WHERE MLK.LOOKUP_CODE = 2
AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE
AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID
AND MKP.SUPPLIER_ID IS NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKP.PULL_SEQUENCE_ID
, MKP.ORGANIZATION_ID
, MKP.KANBAN_PLAN_ID
, MKP.INVENTORY_ITEM_ID
, MKP.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKP.LOCATOR_ID
, MKP.SOURCE_TYPE
, MLK.MEANING SOURCE_TYPE_MEANING
, MKP.LAST_UPDATE_DATE
, MKP.LAST_UPDATED_BY
, MKP.CREATION_DATE
, MKP.CREATED_BY
, MKP.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, MKP.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ITEM_LOC_CONTROL
, NULL SOURCE_ITEM_RESTRICT_SUB
, NULL SOURCE_ITEM_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKP.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKP.SOURCE_LOCATOR_ID
, MKP.WIP_LINE_ID
, WIP.LINE_CODE WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, MKP.CALCULATE_KANBAN_FLAG
, MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.AGGREGATION_TYPE
, MKP.ALLOCATION_PERCENT
, MKP.LAST_UPDATE_LOGIN
, MKP.UPDATED_FLAG
, MKP.RELEASE_KANBAN_FLAG
, MKP.ATTRIBUTE_CATEGORY
, MKP.ATTRIBUTE1
, MKP.ATTRIBUTE2
, MKP.ATTRIBUTE3
, MKP.ATTRIBUTE4
, MKP.ATTRIBUTE5
, MKP.ATTRIBUTE6
, MKP.ATTRIBUTE7
, MKP.ATTRIBUTE8
, MKP.ATTRIBUTE9
, MKP.ATTRIBUTE10
, MKP.ATTRIBUTE11
, MKP.ATTRIBUTE12
, MKP.ATTRIBUTE13
, MKP.ATTRIBUTE14
, MKP.ATTRIBUTE15
, MKP.REQUEST_ID
, MKP.PROGRAM_APPLICATION_ID
, MKP.PROGRAM_ID
, MKP.PROGRAM_UPDATE_DATE
, NVL(MKP.AUTO_REQUEST
, 'N') AUTO_REQUEST
, MKP.AUTO_ALLOCATE_FLAG
FROM WIP_LINES WIP
, MTL_SECONDARY_INVENTORIES MSS
, MTL_KANBAN_PULL_SEQUENCES MKP
, MFG_LOOKUPS MLK
WHERE MLK.LOOKUP_CODE = 4
AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE
AND WIP.LINE_ID = MKP.WIP_LINE_ID
AND WIP.ORGANIZATION_ID = MKP.ORGANIZATION_ID
AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID
AND MKP.WIP_LINE_ID IS NOT NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKP.PULL_SEQUENCE_ID
, MKP.ORGANIZATION_ID
, MKP.KANBAN_PLAN_ID
, MKP.INVENTORY_ITEM_ID
, MKP.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKP.LOCATOR_ID
, MKP.SOURCE_TYPE
, MLK.MEANING SOURCE_TYPE_MEANING
, MKP.LAST_UPDATE_DATE
, MKP.LAST_UPDATED_BY
, MKP.CREATION_DATE
, MKP.CREATED_BY
, MKP.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, MKP.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ITEM_LOC_CONTROL
, NULL SOURCE_ITEM_RESTRICT_SUB
, NULL SOURCE_ITEM_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKP.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKP.SOURCE_LOCATOR_ID
, MKP.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, MKP.CALCULATE_KANBAN_FLAG
, MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.AGGREGATION_TYPE
, MKP.ALLOCATION_PERCENT
, MKP.LAST_UPDATE_LOGIN
, MKP.UPDATED_FLAG
, MKP.RELEASE_KANBAN_FLAG
, MKP.ATTRIBUTE_CATEGORY
, MKP.ATTRIBUTE1
, MKP.ATTRIBUTE2
, MKP.ATTRIBUTE3
, MKP.ATTRIBUTE4
, MKP.ATTRIBUTE5
, MKP.ATTRIBUTE6
, MKP.ATTRIBUTE7
, MKP.ATTRIBUTE8
, MKP.ATTRIBUTE9
, MKP.ATTRIBUTE10
, MKP.ATTRIBUTE11
, MKP.ATTRIBUTE12
, MKP.ATTRIBUTE13
, MKP.ATTRIBUTE14
, MKP.ATTRIBUTE15
, MKP.REQUEST_ID
, MKP.PROGRAM_APPLICATION_ID
, MKP.PROGRAM_ID
, MKP.PROGRAM_UPDATE_DATE
, NVL(MKP.AUTO_REQUEST
, 'N') AUTO_REQUEST
, MKP.AUTO_ALLOCATE_FLAG
FROM MTL_SECONDARY_INVENTORIES MSS
, MTL_KANBAN_PULL_SEQUENCES MKP
, MFG_LOOKUPS MLK
WHERE MLK.LOOKUP_CODE = 4
AND MLK.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKP.SOURCE_TYPE = MLK.LOOKUP_CODE
AND MSS.SECONDARY_INVENTORY_NAME = MKP.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKP.ORGANIZATION_ID
AND MKP.WIP_LINE_ID IS NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL)