VIEW: APPS.WIP_REPETITIVE_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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