VIEW: APPS.WIPFV_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 , 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

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
, 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