VIEW: APPS.WIP_ICX_COMPONENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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