VIEW: APPS.WIPBV_WIP_COMPONENTS

Source

View Text - Preformatted

SELECT '_LA:re.wip_supply_type:MFG_LOOKUPS:WIP_SUPPLY:MEANING' , RE.DATE_REQUIRED , RE.REQUIRED_QUANTITY , RE.QUANTITY_ISSUED , RE.QUANTITY_PER_ASSEMBLY , RE.COMMENTS , '_LA:re.mrp_net_flag:MFG_LOOKUPS:SYS_YES_NO:MEANING' , EN.WIP_ENTITY_NAME , '_KF:INV:MSTK:SY' , RE.WIP_ENTITY_ID , RE.REPETITIVE_SCHEDULE_ID , RE.INVENTORY_ITEM_ID , RE.OPERATION_SEQ_NUM , RE.ORGANIZATION_ID , RE.DEPARTMENT_ID , RE.COMPONENT_SEQUENCE_ID , RE.SUPPLY_LOCATOR_ID , RE.SUPPLY_SUBINVENTORY , RE.CREATION_DATE , RE.CREATED_BY , RE.LAST_UPDATE_DATE , RE.LAST_UPDATED_BY FROM WIP_OPERATIONS OP , WIP_ENTITIES EN , WIP_DISCRETE_JOBS DI , WIP_REPETITIVE_SCHEDULES RESC , MTL_SYSTEM_ITEMS SY , WIP_REQUIREMENT_OPERATIONS RE WHERE RE.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND RE.ORGANIZATION_ID = SY.ORGANIZATION_ID AND NVL(RE.REPETITIVE_SCHEDULE_ID, -1) = NVL(RESC.REPETITIVE_SCHEDULE_ID, -1) AND RE.wip_supply_type <> 6 AND RE.REPETITIVE_SCHEDULE_ID = RESC.REPETITIVE_SCHEDULE_ID(+) AND RE.ORGANIZATION_ID = RESC.ORGANIZATION_ID(+) AND RE.WIP_ENTITY_ID = DI.WIP_ENTITY_ID(+) AND RE.ORGANIZATION_ID = DI.ORGANIZATION_ID(+) AND RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND RE.WIP_ENTITY_ID = OP.WIP_ENTITY_ID(+) AND RE.OPERATION_SEQ_NUM = OP.OPERATION_SEQ_NUM(+) AND RE.ORGANIZATION_ID = OP.ORGANIZATION_ID(+) AND RE.REPETITIVE_SCHEDULE_ID = OP.REPETITIVE_SCHEDULE_ID(+) AND '_SEC:re.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT '_LA:RE.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, RE.DATE_REQUIRED
, RE.REQUIRED_QUANTITY
, RE.QUANTITY_ISSUED
, RE.QUANTITY_PER_ASSEMBLY
, RE.COMMENTS
, '_LA:RE.MRP_NET_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, EN.WIP_ENTITY_NAME
, '_KF:INV:MSTK:SY'
, RE.WIP_ENTITY_ID
, RE.REPETITIVE_SCHEDULE_ID
, RE.INVENTORY_ITEM_ID
, RE.OPERATION_SEQ_NUM
, RE.ORGANIZATION_ID
, RE.DEPARTMENT_ID
, RE.COMPONENT_SEQUENCE_ID
, RE.SUPPLY_LOCATOR_ID
, RE.SUPPLY_SUBINVENTORY
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
FROM WIP_OPERATIONS OP
, WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
, WIP_REPETITIVE_SCHEDULES RESC
, MTL_SYSTEM_ITEMS SY
, WIP_REQUIREMENT_OPERATIONS RE
WHERE RE.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND RE.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND NVL(RE.REPETITIVE_SCHEDULE_ID
, -1) = NVL(RESC.REPETITIVE_SCHEDULE_ID
, -1)
AND RE.WIP_SUPPLY_TYPE <> 6
AND RE.REPETITIVE_SCHEDULE_ID = RESC.REPETITIVE_SCHEDULE_ID(+)
AND RE.ORGANIZATION_ID = RESC.ORGANIZATION_ID(+)
AND RE.WIP_ENTITY_ID = DI.WIP_ENTITY_ID(+)
AND RE.ORGANIZATION_ID = DI.ORGANIZATION_ID(+)
AND RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND RE.WIP_ENTITY_ID = OP.WIP_ENTITY_ID(+)
AND RE.OPERATION_SEQ_NUM = OP.OPERATION_SEQ_NUM(+)
AND RE.ORGANIZATION_ID = OP.ORGANIZATION_ID(+)
AND RE.REPETITIVE_SCHEDULE_ID = OP.REPETITIVE_SCHEDULE_ID(+)
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY