VIEW: APPS.WIPBV_WIP_REPETITIVE_ITEMS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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