View: MTL_KANBAN_PULL_SEQUENCES_V

Product:	INV - Inventory
Description:	retrofitted
Implementation/DBA Data:	APPS.MTL_KANBAN_PULL_SEQUENCES_V

View Text

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)

Columns