VIEW: APPS.WIPFV_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 , 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

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
, 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