View: WIPFV_WIP_COMPONENTS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_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
, ST.OPERATION_CODE
, '_KF:INV:MSTK:SY'
, PA.ORGANIZATION_CODE
, AL.NAME
, DE.DEPARTMENT_CODE
, IT.DESCRIPTION
, '_DF:BOM:BOM_INVENTORY_COMPONENTS:RE'
, RE.WIP_ENTITY_ID
, RE.REPETITIVE_SCHEDULE_ID
, RE.OPERATION_SEQ_NUM
, RE.INVENTORY_ITEM_ID
, 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 BOM_STANDARD_OPERATIONS ST
, BOM_DEPARTMENTS DE
, MTL_ITEM_LOCATIONS IT
, MTL_SECONDARY_INVENTORIES SE
, WIP_OPERATIONS OP
, WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
, WIP_REPETITIVE_SCHEDULES RESC
, MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_REQUIREMENT_OPERATIONS RE
WHERE RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND 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.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND RE.WIP_ENTITY_ID = OP.WIP_ENTITY_ID
AND NVL( RE.REPETITIVE_SCHEDULE_ID
, -1) = NVL(OP.REPETITIVE_SCHEDULE_ID
, -1)
AND RE.ORGANIZATION_ID = OP.ORGANIZATION_ID
AND RE.OPERATION_SEQ_NUM = OP.OPERATION_SEQ_NUM
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 OP.STANDARD_OPERATION_ID = ST.STANDARD_OPERATION_ID(+)
AND RE.DEPARTMENT_ID = DE.DEPARTMENT_ID(+)
AND RE.SUPPLY_LOCATOR_ID = IT.INVENTORY_LOCATION_ID(+)
AND RE.ORGANIZATION_ID = IT.ORGANIZATION_ID(+)
AND RE.SUPPLY_SUBINVENTORY = SE.SECONDARY_INVENTORY_NAME(+)
AND RE.ORGANIZATION_ID = SE.ORGANIZATION_ID(+)
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns