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.JMF_SHIKYU_SPR_RPT_COM_V

Source

View Text - Preformatted


SELECT com.subcontract_po_shipment_id, com.shikyu_component_id, jmf_shikyu_rpt_util.get_item_number(com.oem_organization_id, com.shikyu_component_id) item_number, mtl2.description, com.primary_uom_price shikyu_component_price, lk.meaning subcontracting_component, com.currency, (SELECT wipre.required_quantity FROM wip_requirement_operations wipre WHERE wipre.wip_entity_id = sub.wip_entity_id AND wipre.inventory_item_id = com.shikyu_component_id AND wipre.organization_id = sub.tp_organization_id) required_quantity, com.primary_uom uom, mtl.UNIT_OF_MEASURE, sub.oem_organization_id, sub.osa_item_id FROM jmf_subcontract_orders sub, mtl_system_items_b mtl2, jmf_shikyu_components com, mtl_units_of_measure_tl mtl, FND_LOOKUP_VALUES lk WHERE sub.subcontract_po_shipment_id = com.subcontract_po_shipment_id AND mtl2.inventory_item_id = com.shikyu_component_id AND mtl2.organization_id = com.oem_organization_id AND lk.lookup_code (+) = mtl2.subcontracting_component AND lk.lookup_type='JMF_SHK_ITEM_REPLEN_TYPE' and com.primary_uom = mtl.uom_code AND mtl.LANGUAGE= USERENV ('LANG') and lk.language =USERENV ('LANG')

View Text - HTML Formatted

SELECT COM.SUBCONTRACT_PO_SHIPMENT_ID
, COM.SHIKYU_COMPONENT_ID
, JMF_SHIKYU_RPT_UTIL.GET_ITEM_NUMBER(COM.OEM_ORGANIZATION_ID
, COM.SHIKYU_COMPONENT_ID) ITEM_NUMBER
, MTL2.DESCRIPTION
, COM.PRIMARY_UOM_PRICE SHIKYU_COMPONENT_PRICE
, LK.MEANING SUBCONTRACTING_COMPONENT
, COM.CURRENCY
, (SELECT WIPRE.REQUIRED_QUANTITY
FROM WIP_REQUIREMENT_OPERATIONS WIPRE
WHERE WIPRE.WIP_ENTITY_ID = SUB.WIP_ENTITY_ID
AND WIPRE.INVENTORY_ITEM_ID = COM.SHIKYU_COMPONENT_ID
AND WIPRE.ORGANIZATION_ID = SUB.TP_ORGANIZATION_ID) REQUIRED_QUANTITY
, COM.PRIMARY_UOM UOM
, MTL.UNIT_OF_MEASURE
, SUB.OEM_ORGANIZATION_ID
, SUB.OSA_ITEM_ID
FROM JMF_SUBCONTRACT_ORDERS SUB
, MTL_SYSTEM_ITEMS_B MTL2
, JMF_SHIKYU_COMPONENTS COM
, MTL_UNITS_OF_MEASURE_TL MTL
, FND_LOOKUP_VALUES LK
WHERE SUB.SUBCONTRACT_PO_SHIPMENT_ID = COM.SUBCONTRACT_PO_SHIPMENT_ID
AND MTL2.INVENTORY_ITEM_ID = COM.SHIKYU_COMPONENT_ID
AND MTL2.ORGANIZATION_ID = COM.OEM_ORGANIZATION_ID
AND LK.LOOKUP_CODE (+) = MTL2.SUBCONTRACTING_COMPONENT
AND LK.LOOKUP_TYPE='JMF_SHK_ITEM_REPLEN_TYPE'
AND COM.PRIMARY_UOM = MTL.UOM_CODE
AND MTL.LANGUAGE= USERENV ('LANG')
AND LK.LANGUAGE =USERENV ('LANG')