eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WIP_EAM_REQUIREMENTS_ALL_V

Source

View Text - Preformatted


SELECT WRO.ROWID ROW_ID , WRO.INVENTORY_ITEM_ID , MSIK.CONCATENATED_SEGMENTS , MSIK.DESCRIPTION ITEM_DESCRIPTION , MSIK.PRIMARY_UOM_CODE ITEM_PRIMARY_UOM_CODE , MSIK.INVENTORY_ASSET_FLAG , MSIK.LOCATION_CONTROL_CODE , MSIK.RESTRICT_LOCATORS_CODE , MSIK.RESTRICT_SUBINVENTORIES_CODE , WRO.ORGANIZATION_ID , WRO.WIP_ENTITY_ID , WRO.OPERATION_SEQ_NUM , WRO.LAST_UPDATE_DATE , WRO.LAST_UPDATED_BY , WRO.CREATION_DATE , WRO.CREATED_BY , WRO.LAST_UPDATE_LOGIN , WRO.REQUEST_ID , WRO.PROGRAM_APPLICATION_ID , WRO.PROGRAM_ID , WRO.PROGRAM_UPDATE_DATE , WRO.DEPARTMENT_ID , BD.DEPARTMENT_CODE , WRO.WIP_SUPPLY_TYPE , ML1.MEANING WIP_SUPPLY_MEANING , WRO.DATE_REQUIRED , WRO.REQUIRED_QUANTITY , DECODE(WRO.QUANTITY_ISSUED, 0,to_number(NULL), WRO.QUANTITY_ISSUED) QUANTITY_ISSUED , (wro.required_quantity-NVL(wro.quantity_issued,0) - eam_material_allocqty_pkg.allocated_quantity(wro.wip_entity_id,wro.operation_seq_num, wro.organization_id,wro.inventory_item_id)) QUANTITY_OPEN , WRO.QUANTITY_PER_ASSEMBLY , WRO.COMMENTS , WRO.SUPPLY_SUBINVENTORY , WRO.SUPPLY_LOCATOR_ID , WRO.MRP_NET_FLAG, WRO.MPS_REQUIRED_QUANTITY , WRO.MPS_DATE_REQUIRED , DECODE(WOP.OPERATION_SEQ_NUM, to_number(NULL),0,1) ROUTING_EXISTS_FLAG , WOP.FIRST_UNIT_START_DATE , WOP.FIRST_UNIT_COMPLETION_DATE , WOP.LAST_UNIT_COMPLETION_DATE , eam_material_allocqty_pkg.allocated_quantity(wro.wip_entity_id,wro.operation_seq_num, wro.organization_id,wro.inventory_item_id) QUANTITY_ALLOCATED , WRO.AUTO_REQUEST_MATERIAL FROM MTL_SYSTEM_ITEMS_KFV MSIK , WIP_OPERATIONS WOP , BOM_DEPARTMENTS BD , MFG_LOOKUPS ML1 , WIP_REQUIREMENT_OPERATIONS WRO WHERE MSIK.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID AND MSIK.ORGANIZATION_ID = WRO.ORGANIZATION_ID AND nvl(msik.stock_enabled_flag, 'N') = 'Y' AND WRO.ORGANIZATION_ID = WOP.ORGANIZATION_ID(+) AND WRO.WIP_ENTITY_ID = WOP.WIP_ENTITY_ID(+) AND WRO.REPETITIVE_SCHEDULE_ID IS NULL AND WRO.OPERATION_SEQ_NUM = WOP.OPERATION_SEQ_NUM(+) AND WRO.ORGANIZATION_ID = WOP.ORGANIZATION_ID (+) AND WRO.WIP_ENTITY_ID = WOP.WIP_ENTITY_ID (+) AND BD.DEPARTMENT_ID(+) = WRO.DEPARTMENT_ID AND ML1.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE AND ML1.LOOKUP_TYPE = 'WIP_SUPPLY' AND MSIK.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID AND MSIK.ORGANIZATION_ID = WRO.ORGANIZATION_ID UNION SELECT chartorowid(null) ROW_ID , edir.inventory_item_ID , edir.item_description, edir.DESCRIPTION, edir.UOM_CODE , null INVENTORY_ASSET_FLAG, to_number(NULL) LOCATION_CONTROL_CODE , to_number(NULL) RESTRICT_LOCATORS_CODE , to_number(NULL) RESTRICT_SUBINVENTORIES_CODE , edir.ORGANIZATION_ID, edir.WIP_ENTITY_ID, edir.task_number, to_date(null) LAST_UPDATE_DATE , to_number(NULL) LAST_UPDATED_BY , to_date(null) CREATION_DATE, to_number(NULL) CREATED_BY, to_number(NULL) LAST_UPDATE_LOGIN , to_number(NULL) REQUEST_ID, to_number(NULL) PROGRAM_APPLICATION_ID, to_number(NULL) PROGRAM_ID, to_date(null) PROGRAM_UPDATE_DATE , to_number(NULL) DEPARTMENT_ID , null DEPARTMENT_CODE, to_number(NULL) WIP_SUPPLY_TYPE, null WIP_SUPPLY_MEANING, to_date(null) DATE_REQUIRED, edir.REQUIRED_QUANTITY REQUIRED_QUANTITY, edir.QUANTITY_RECEIVED QUANTITY_ISSUED, nvl(nvl(edir.REQUIRED_QUANTITY,0) - greatest(nvl(edir.po_quantity_ordered,0), nvl(edir.rql_quantity_ordered,0)), 0) QUANTITY_OPEN, to_number(NULL) QUANTITY_PER_ASSEMBLY, null COMMENTS , null SUPPLY_SUBINVENTORY , to_number(NULL) SUPPLY_LOCATOR_ID , to_number(NULL) MRP_NET_FLAG , to_number(NULL) MPS_REQUIRED_QUANTITY, to_date(null) MPS_DATE_REQUIRED, to_number(NULL) ROUTING_EXISTS_FLAG, to_date(null) FIRST_UNIT_START_DATE, to_date(null) FIRST_UNIT_COMPLETION_DATE, to_date(null) LAST_UNIT_COMPLETION_DATE, to_number(NULL) QUANTITY_ALLOCATED, edir.AUTO_REQUEST_MATERIAL AUTO_REQUEST_MATERIAL FROM EAM_DIRECT_ITEM_RECS_V edir

View Text - HTML Formatted

SELECT WRO.ROWID ROW_ID
, WRO.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, MSIK.DESCRIPTION ITEM_DESCRIPTION
, MSIK.PRIMARY_UOM_CODE ITEM_PRIMARY_UOM_CODE
, MSIK.INVENTORY_ASSET_FLAG
, MSIK.LOCATION_CONTROL_CODE
, MSIK.RESTRICT_LOCATORS_CODE
, MSIK.RESTRICT_SUBINVENTORIES_CODE
, WRO.ORGANIZATION_ID
, WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.LAST_UPDATE_DATE
, WRO.LAST_UPDATED_BY
, WRO.CREATION_DATE
, WRO.CREATED_BY
, WRO.LAST_UPDATE_LOGIN
, WRO.REQUEST_ID
, WRO.PROGRAM_APPLICATION_ID
, WRO.PROGRAM_ID
, WRO.PROGRAM_UPDATE_DATE
, WRO.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, WRO.WIP_SUPPLY_TYPE
, ML1.MEANING WIP_SUPPLY_MEANING
, WRO.DATE_REQUIRED
, WRO.REQUIRED_QUANTITY
, DECODE(WRO.QUANTITY_ISSUED
, 0
, TO_NUMBER(NULL)
, WRO.QUANTITY_ISSUED) QUANTITY_ISSUED
, (WRO.REQUIRED_QUANTITY-NVL(WRO.QUANTITY_ISSUED
, 0) - EAM_MATERIAL_ALLOCQTY_PKG.ALLOCATED_QUANTITY(WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.ORGANIZATION_ID
, WRO.INVENTORY_ITEM_ID)) QUANTITY_OPEN
, WRO.QUANTITY_PER_ASSEMBLY
, WRO.COMMENTS
, WRO.SUPPLY_SUBINVENTORY
, WRO.SUPPLY_LOCATOR_ID
, WRO.MRP_NET_FLAG
, WRO.MPS_REQUIRED_QUANTITY
, WRO.MPS_DATE_REQUIRED
, DECODE(WOP.OPERATION_SEQ_NUM
, TO_NUMBER(NULL)
, 0
, 1) ROUTING_EXISTS_FLAG
, WOP.FIRST_UNIT_START_DATE
, WOP.FIRST_UNIT_COMPLETION_DATE
, WOP.LAST_UNIT_COMPLETION_DATE
, EAM_MATERIAL_ALLOCQTY_PKG.ALLOCATED_QUANTITY(WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.ORGANIZATION_ID
, WRO.INVENTORY_ITEM_ID) QUANTITY_ALLOCATED
, WRO.AUTO_REQUEST_MATERIAL
FROM MTL_SYSTEM_ITEMS_KFV MSIK
, WIP_OPERATIONS WOP
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS ML1
, WIP_REQUIREMENT_OPERATIONS WRO
WHERE MSIK.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WRO.ORGANIZATION_ID
AND NVL(MSIK.STOCK_ENABLED_FLAG
, 'N') = 'Y'
AND WRO.ORGANIZATION_ID = WOP.ORGANIZATION_ID(+)
AND WRO.WIP_ENTITY_ID = WOP.WIP_ENTITY_ID(+)
AND WRO.REPETITIVE_SCHEDULE_ID IS NULL
AND WRO.OPERATION_SEQ_NUM = WOP.OPERATION_SEQ_NUM(+)
AND WRO.ORGANIZATION_ID = WOP.ORGANIZATION_ID (+)
AND WRO.WIP_ENTITY_ID = WOP.WIP_ENTITY_ID (+)
AND BD.DEPARTMENT_ID(+) = WRO.DEPARTMENT_ID
AND ML1.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE
AND ML1.LOOKUP_TYPE = 'WIP_SUPPLY'
AND MSIK.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WRO.ORGANIZATION_ID UNION SELECT CHARTOROWID(NULL) ROW_ID
, EDIR.INVENTORY_ITEM_ID
, EDIR.ITEM_DESCRIPTION
, EDIR.DESCRIPTION
, EDIR.UOM_CODE
, NULL INVENTORY_ASSET_FLAG
, TO_NUMBER(NULL) LOCATION_CONTROL_CODE
, TO_NUMBER(NULL) RESTRICT_LOCATORS_CODE
, TO_NUMBER(NULL) RESTRICT_SUBINVENTORIES_CODE
, EDIR.ORGANIZATION_ID
, EDIR.WIP_ENTITY_ID
, EDIR.TASK_NUMBER
, TO_DATE(NULL) LAST_UPDATE_DATE
, TO_NUMBER(NULL) LAST_UPDATED_BY
, TO_DATE(NULL) CREATION_DATE
, TO_NUMBER(NULL) CREATED_BY
, TO_NUMBER(NULL) LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) REQUEST_ID
, TO_NUMBER(NULL) PROGRAM_APPLICATION_ID
, TO_NUMBER(NULL) PROGRAM_ID
, TO_DATE(NULL) PROGRAM_UPDATE_DATE
, TO_NUMBER(NULL) DEPARTMENT_ID
, NULL DEPARTMENT_CODE
, TO_NUMBER(NULL) WIP_SUPPLY_TYPE
, NULL WIP_SUPPLY_MEANING
, TO_DATE(NULL) DATE_REQUIRED
, EDIR.REQUIRED_QUANTITY REQUIRED_QUANTITY
, EDIR.QUANTITY_RECEIVED QUANTITY_ISSUED
, NVL(NVL(EDIR.REQUIRED_QUANTITY
, 0) - GREATEST(NVL(EDIR.PO_QUANTITY_ORDERED
, 0)
, NVL(EDIR.RQL_QUANTITY_ORDERED
, 0))
, 0) QUANTITY_OPEN
, TO_NUMBER(NULL) QUANTITY_PER_ASSEMBLY
, NULL COMMENTS
, NULL SUPPLY_SUBINVENTORY
, TO_NUMBER(NULL) SUPPLY_LOCATOR_ID
, TO_NUMBER(NULL) MRP_NET_FLAG
, TO_NUMBER(NULL) MPS_REQUIRED_QUANTITY
, TO_DATE(NULL) MPS_DATE_REQUIRED
, TO_NUMBER(NULL) ROUTING_EXISTS_FLAG
, TO_DATE(NULL) FIRST_UNIT_START_DATE
, TO_DATE(NULL) FIRST_UNIT_COMPLETION_DATE
, TO_DATE(NULL) LAST_UNIT_COMPLETION_DATE
, TO_NUMBER(NULL) QUANTITY_ALLOCATED
, EDIR.AUTO_REQUEST_MATERIAL AUTO_REQUEST_MATERIAL
FROM EAM_DIRECT_ITEM_RECS_V EDIR