View: WIPFV_WIP_REPETITIVE_ITEMS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_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
, PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY'
, IT.DESCRIPTION
, 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 MTL_SECONDARY_INVENTORIES SE
, MTL_ITEM_LOCATIONS IT
, MTL_SYSTEM_ITEMS SY
, WIP_LINES LI
, WIP_ACCOUNTING_CLASSES AC
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_ENTITIES EN
, WIP_REPETITIVE_ITEMS RE
WHERE RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RE.CLASS_CODE = AC.CLASS_CODE
AND RE.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND RE.LINE_ID = LI.LINE_ID
AND RE.ORGANIZATION_ID = LI.ORGANIZATION_ID
AND RE.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND RE.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND RE.COMPLETION_LOCATOR_ID= IT.INVENTORY_LOCATION_ID(+)
AND RE.ORGANIZATION_ID = IT.ORGANIZATION_ID(+)
AND RE.COMPLETION_SUBINVENTORY = SE.SECONDARY_INVENTORY_NAME(+)
AND RE.ORGANIZATION_ID = SE.ORGANIZATION_ID(+)
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns