View: WIPBV_WIP_REPETITIVE_ITEMS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPBV_WIP_REPETITIVE_ITEMS

View Text

SELECT RE.ALTERNATE_BOM_DESIGNATOR
, RE.ALTERNATE_ROUTING_DESIGNATOR
, '_LA:RE.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, RE.LOAD_DISTRIBUTION_PRIORITY
, '_LA:RE.PRIMARY_LINE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, RE.PRODUCTION_LINE_RATE
, '_LA:RE.OVERCOMPLETION_TOLERANCE_TYPE:MFG_LOOKUPS:WIP_TOLERANCE_TYPE:MEANING'
, RE.OVERCOMPLETION_TOLERANCE_VALUE
, EN.WIP_ENTITY_NAME
, LI.LINE_CODE
, RE.WIP_ENTITY_ID
, RE.LINE_ID
, RE.ORGANIZATION_ID
, RE.PRIMARY_ITEM_ID
, RE.CLASS_CODE
, RE.COMPLETION_SUBINVENTORY
, RE.COMPLETION_LOCATOR_ID
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_LINES LI
, WIP_REPETITIVE_ITEMS RE
WHERE RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND RE.LINE_ID = LI.LINE_ID
AND RE.ORGANIZATION_ID = LI.ORGANIZATION_ID
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns