Product: | WIP - Work in Process |
---|---|
Description: | Foreign-key data for WIP_REPETITIVE_ITEMS |
Implementation/DBA Data: | APPS.WIP_REPETITIVE_ITEMS_V |
SELECT WRI.ROWID ROW_ID
, WRI.WIP_ENTITY_ID
, WRI.LINE_ID
, WL.LINE_CODE
, WL.DESCRIPTION LINE_DESCRIPTION
, WL.LINE_SCHEDULE_TYPE
, WL.MINIMUM_RATE LINE_MINIMUM_RATE
, WL.MAXIMUM_RATE LINE_MAXIMUM_RATE
, WL.FIXED_THROUGHPUT LINE_FIXED_THROUGHPUT
, ML.MEANING WIP_SUPPLY_TEXT
, WRI.ORGANIZATION_ID
, WRI.LAST_UPDATE_DATE
, WRI.LAST_UPDATED_BY
, WRI.CREATION_DATE
, WRI.CREATED_BY
, WRI.LAST_UPDATE_LOGIN
, WRI.REQUEST_ID
, WRI.PROGRAM_APPLICATION_ID
, WRI.PROGRAM_ID
, WRI.PROGRAM_UPDATE_DATE
, WRI.PRIMARY_ITEM_ID
, WRI.ALTERNATE_BOM_DESIGNATOR
, WRI.ALTERNATE_ROUTING_DESIGNATOR
, WRI.CLASS_CODE
, WRI.WIP_SUPPLY_TYPE
, WRI.COMPLETION_SUBINVENTORY
, WRI.COMPLETION_LOCATOR_ID
, WRI.LOAD_DISTRIBUTION_PRIORITY
, WRI.PRIMARY_LINE_FLAG
, WRI.PRODUCTION_LINE_RATE
, WRI.ATTRIBUTE_CATEGORY
, WRI.ATTRIBUTE1
, WRI.ATTRIBUTE2
, WRI.ATTRIBUTE3
, WRI.ATTRIBUTE4
, WRI.ATTRIBUTE5
, WRI.ATTRIBUTE6
, WRI.ATTRIBUTE7
, WRI.ATTRIBUTE8
, WRI.ATTRIBUTE9
, WRI.ATTRIBUTE10
, WRI.ATTRIBUTE11
, WRI.ATTRIBUTE12
, WRI.ATTRIBUTE13
, WRI.ATTRIBUTE14
, WRI.ATTRIBUTE15
, NVL(MSV.LOCATOR_TYPE
, 1) LOCATOR_TYPE
, WRI.OVERCOMPLETION_TOLERANCE_TYPE
, WRI.OVERCOMPLETION_TOLERANCE_VALUE
FROM WIP_LINES WL
, MFG_LOOKUPS ML
, MTL_SECONDARY_INVENTORIES MSV
, WIP_REPETITIVE_ITEMS WRI
WHERE WL.LINE_ID = WRI.LINE_ID
AND WL.ORGANIZATION_ID = WRI.ORGANIZATION_ID
AND MSV.SECONDARY_INVENTORY_NAME (+) = WRI.COMPLETION_SUBINVENTORY
AND MSV.ORGANIZATION_ID (+) = WRI.ORGANIZATION_ID
AND ML.LOOKUP_TYPE = 'WIP_SUPPLY'
AND ML.LOOKUP_CODE = WRI.WIP_SUPPLY_TYPE