View: WIP_ICX_COMPONENTS_V

Product:	WIP - Work in Process
Description:	Component information for job/schedule operations
Implementation/DBA Data:	APPS.WIP_ICX_COMPONENTS_V

View Text

SELECT WRO.WIP_ENTITY_ID
, WRO.REPETITIVE_SCHEDULE_ID
, WRO.ORGANIZATION_ID
, WRO.OPERATION_SEQ_NUM
, WRO.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, MSIK.DESCRIPTION
, MSIK.PRIMARY_UOM_CODE
, WRO.QUANTITY_PER_ASSEMBLY
, LO.MEANING
, DECODE(FND_ATTACHMENT_UTIL_PKG.GET_ATCHMT_EXISTS('MTL_SYSTEM_ITEMS'
, WRO.ORGANIZATION_ID
, WRO.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL
, 'WIP_WIPMRMDF'
, 'F')
, 'Y'
, FND_MESSAGE.GET_STRING('WIP'
, 'AVAILABLE')
, NULL)
, WRO.CREATION_DATE
, WRO.CREATED_BY
, WRO.LAST_UPDATE_DATE
, WRO.LAST_UPDATED_BY
FROM WIP_OPERATIONS WO
, BOM_DEPARTMENTS BD
, MTL_SYSTEM_ITEMS_KFV MSIK
, MFG_LOOKUPS LO
, WIP_REQUIREMENT_OPERATIONS WRO
WHERE WRO.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND WRO.ORGANIZATION_ID = MSIK.ORGANIZATION_ID AND WRO.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND LO.LOOKUP_TYPE = 'WIP_SUPPLY'
AND LO.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE AND WRO.ORGANIZATION_ID = WO.ORGANIZATION_ID AND WRO.WIP_ENTITY_ID = WO.WIP_ENTITY_ID AND NVL(WRO.REPETITIVE_SCHEDULE_ID
, -1) = NVL(WO.REPETITIVE_SCHEDULE_ID
, -1) AND WRO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM

Columns