View: WIPBV_WIP_COMPONENTS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPBV_WIP_COMPONENTS

View Text

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

Columns