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.

APPS.GMPMPACT dependencies on MTL_SYSTEM_ITEMS

Line 302: ' mtl_system_items_kfv msi, '||

298: x_select := x_select || ' mtl_categories_kfv mca, ';
299: END IF;
300:
301: x_select := x_select ||
302: ' mtl_system_items_kfv msi, '||
303: ' mtl_item_categories mic, '||
304: ' ps_schd_dtl psd, '||
305: ' mtl_category_sets mcs '||
306: ' WHERE '||

Line 585: MTL_SYSTEM_ITEMS mitem,

581:
582: CURSOR Cur_po_doc_no IS
583: SELECT po.po_number
584: FROM MTL_PARAMETERS mtl,
585: MTL_SYSTEM_ITEMS mitem,
586: -- IC_ITEM_MST ic,
587: PO_PO_SUPPLY_VIEW po
588: WHERE po.item_id = mitem.inventory_item_id
589: AND po.to_organization_id = mitem.organization_id

Line 607: MTL_SYSTEM_ITEMS mitem,

603:
604: CURSOR Cur_requisition_details IS
605: SELECT po.requisition_number
606: FROM MTL_PARAMETERS mtl,
607: MTL_SYSTEM_ITEMS mitem,
608: -- IC_ITEM_MST ic,
609: PO_REQ_SUPPLY_VIEW po
610: WHERE po.item_id = mitem.inventory_item_id
611: AND po.to_organization_id = mitem.organization_id

Line 628: MTL_SYSTEM_ITEMS mitem,

624:
625: CURSOR Cur_receiving_details IS
626: SELECT ph.segment1
627: FROM MTL_PARAMETERS mtl,
628: MTL_SYSTEM_ITEMS mitem,
629: -- IC_ITEM_MST ic,
630: PO_HEADERS_ALL ph,
631: PO_RCV_SUPPLY_VIEW po
632: WHERE po.item_id = mitem.inventory_item_id

Line 651: MTL_SYSTEM_ITEMS mitem,

647: AND G_doc_type = 'PRCV'
648: UNION ALL
649: SELECT rsh.receipt_num
650: FROM MTL_PARAMETERS mtl,
651: MTL_SYSTEM_ITEMS mitem,
652: -- IC_ITEM_MST ic,
653: RCV_SHIPMENT_HEADERS rsh,
654: PO_SHIP_RCV_SUPPLY_VIEW po
655: WHERE po.item_id = mitem.inventory_item_id

Line 670: MTL_SYSTEM_ITEMS mitem,

666:
667: CURSOR Cur_shipment_details IS
668: SELECT rsh.receipt_num
669: FROM MTL_PARAMETERS mtl,
670: MTL_SYSTEM_ITEMS mitem,
671: -- IC_ITEM_MST ic,
672: RCV_SHIPMENT_HEADERS rsh,
673: PO_SHIP_SUPPLY_VIEW po
674: WHERE po.item_id = mitem.inventory_item_id

Line 793: ' mtl_system_items msi '||

789: ' gme_batch_header gbh, '||
790: ' gme_material_details gmd, '||
791: ' mtl_parameters mp, '||
792: ' hr_organization_units hou, '||
793: ' mtl_system_items msi '||
794: ' WHERE '||
795: ' Gbh.batch_id = gmd.batch_id '||
796: ' AND msi.inventory_item_id = gmd.inventory_item_id '||
797: ' AND msi.organization_id = gmd.organization_id '||

Line 829: ' mtl_system_items items, '||

825: ' )) trans_qty2, '||
826: ' dtl.line_id line_id, org.organization_code inv_org_code '||
827: 'FROM '||
828: ' mtl_demand_omoe mtl, '||
829: ' mtl_system_items items, '||
830: ' oe_order_headers_all hdr, '||
831: ' oe_order_lines_all dtl, '||
832: ' hr_organization_units hou, '||
833: ' mtl_parameters org '||

Line 892: ' mtl_system_items msi, '||

888: ' FROM '||
889: ' ps_schd_for psf, '||
890: ' mrp_forecast_designators mff, '||
891: ' mrp_forecast_dates dtl, '||
892: ' mtl_system_items msi, '||
893: ' hr_organization_units hou, '||
894: ' mtl_parameters mp '||
895: ' WHERE dtl.inventory_item_id = TO_CHAR(:item_id) '||
896: ' AND psf.schedule_id = TO_CHAR(:schedule_id) '||

Line 932: ' po_po_supply_view po, mtl_system_items mitem '||

928: --' po.po_line_location_id line_id, mtl.organization_code inv_org_code '||
929: ' po.po_line_id line_id, mtl.organization_code inv_org_code '||
930: ' FROM MTL_PARAMETERS mtl, '||
931: ' hr_organization_units hou, '||
932: ' po_po_supply_view po, mtl_system_items mitem '||
933: ' WHERE po.item_id = TO_CHAR(:item_id) '||
934: ' AND po.item_id = mitem.inventory_item_id '||
935: ' AND po.to_organization_id = mitem.organization_id '||
936: ' AND mtl.organization_id = po.to_organization_id '||

Line 964: ' po_req_supply_view po, mtl_system_items mitem '||

960: ' NULL )) trans_qty2, '||
961: ' po.req_line_id, mtl.organization_code '||
962: ' FROM MTL_PARAMETERS mtl, '||
963: ' hr_organization_units hou, '||
964: ' po_req_supply_view po, mtl_system_items mitem '||
965: ' WHERE po.item_id = TO_CHAR(:item_id) '||
966: ' AND po.item_id = mitem.inventory_item_id '||
967: ' AND po.to_organization_id = mitem.organization_id '||
968: ' AND mtl.organization_id = po.to_organization_id '||

Line 996: ' po_rcv_supply_view po, mtl_system_items mitem '||

992: ' NULL)) trans_qty2, '||
993: ' po.po_line_id line_id, mtl.organization_code inv_org_code '||
994: ' FROM MTL_PARAMETERS mtl, '||
995: ' hr_organization_units hou, '||
996: ' po_rcv_supply_view po, mtl_system_items mitem '||
997: ' WHERE po.item_id = TO_CHAR(:item_id) '||
998: ' AND po.item_id = mitem.inventory_item_id '||
999: ' AND po.to_organization_id = mitem.organization_id '||
1000: ' AND mtl.organization_id = po.to_organization_id '||

Line 1028: ' po_ship_rcv_supply_view po, mtl_system_items mitem '||

1024: ' NULL)) trans_qty2, '||
1025: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1026: ' FROM MTL_PARAMETERS mtl, '||
1027: ' hr_organization_units hou, '||
1028: ' po_ship_rcv_supply_view po, mtl_system_items mitem '||
1029: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1030: ' AND po.item_id = mitem.inventory_item_id '||
1031: ' AND po.to_organization_id = mitem.organization_id '||
1032: ' AND mtl.organization_id = po.to_organization_id '||

Line 1056: ' po_ship_supply_view po, mtl_system_items mitem '||

1052: ' NULL)) trans_qty2, '||
1053: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1054: ' FROM MTL_PARAMETERS mtl, '||
1055: ' hr_organization_units hou, '||
1056: ' po_ship_supply_view po, mtl_system_items mitem '||
1057: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1058: ' AND po.item_id = mitem.inventory_item_id '||
1059: ' AND po.to_organization_id = mitem.organization_id '||
1060: ' AND mtl.organization_id = po.to_organization_id '||

Line 1534: MTL_SYSTEM_ITEMS mitem,

1530: SELECT UNIQUE substr(pv.vendor_name,1,32)
1531: -- UNIQUE pv.segment1
1532: FROM MTL_PARAMETERS mtl,
1533: PO_VENDORS pv,
1534: MTL_SYSTEM_ITEMS mitem,
1535: -- IC_ITEM_MST ic,
1536: PO_PO_SUPPLY_VIEW po
1537: WHERE po.item_id = mitem.inventory_item_id
1538: AND pv.vendor_id = po.vendor_id

Line 1559: MTL_SYSTEM_ITEMS mitem,

1555: SELECT UNIQUE substr(pv.vendor_name,1,32)
1556: -- UNIQUE pv.segment1
1557: FROM MTL_PARAMETERS mtl,
1558: PO_VENDORS pv,
1559: MTL_SYSTEM_ITEMS mitem,
1560: -- IC_ITEM_MST ic,
1561: PO_RCV_SUPPLY_VIEW po
1562: WHERE po.item_id = mitem.inventory_item_id
1563: AND pv.vendor_id = po.vendor_id

Line 1584: MTL_SYSTEM_ITEMS mitem,

1580: SELECT UNIQUE substr(pv.vendor_name,1,32)
1581: -- UNIQUE pv.segment1
1582: FROM MTL_PARAMETERS mtl,
1583: PO_VENDORS pv,
1584: MTL_SYSTEM_ITEMS mitem,
1585: -- IC_ITEM_MST ic,
1586: RCV_SHIPMENT_HEADERS rsh,
1587: PO_SHIP_RCV_SUPPLY_VIEW po
1588: WHERE po.item_id = mitem.inventory_item_id

Line 1606: MTL_SYSTEM_ITEMS mitem,

1602: --Modified to vendor_name from segment1 as per bug # 11068148
1603: SELECT UNIQUE substr(pv.vendor_name,1,32)
1604: -- UNIQUE pv.segment1
1605: FROM MTL_PARAMETERS mtl,
1606: MTL_SYSTEM_ITEMS mitem,
1607: -- IC_ITEM_MST ic,
1608: PO_VENDORS pv,
1609: RCV_SHIPMENT_HEADERS rsh,
1610: PO_SHIP_SUPPLY_VIEW po

Line 1628: MTL_SYSTEM_ITEMS mitem,

1624:
1625: CURSOR Cur_requisition_details IS
1626: SELECT SUBSTRB(prl.suggested_vendor_name,1,40)
1627: FROM MTL_PARAMETERS mtl,
1628: MTL_SYSTEM_ITEMS mitem,
1629: -- IC_ITEM_MST ic,
1630: -- IC_WHSE_MST iwm,
1631: PO_REQUISITION_LINES_ALL prl,
1632: PO_REQ_SUPPLY_VIEW po

Line 1985: FROM mtl_system_items_kfv

1981: v_item_name VARCHAR2(240);
1982: BEGIN
1983:
1984: SELECT concatenated_segments INTO v_item_name
1985: FROM mtl_system_items_kfv
1986: WHERE inventory_item_id = p_inventory_item_id
1987: AND organization_id = p_organization_id;
1988:
1989: RETURN v_item_name;

Line 2041: FROM mtl_system_items

2037: v_planner_code VARCHAR2(10);
2038: BEGIN
2039:
2040: SELECT planner_code INTO v_planner_code
2041: FROM mtl_system_items
2042: WHERE inventory_item_id = p_inventory_item_id
2043: AND organization_id = p_organization_id;
2044:
2045: RETURN v_planner_code;

Line 2071: FROM mtl_system_items msi, hr_employees he

2067: v_buyer_name VARCHAR2(240);
2068: BEGIN
2069:
2070: SELECT he.full_name INTO v_buyer_name
2071: FROM mtl_system_items msi, hr_employees he
2072: WHERE inventory_item_id = p_inventory_item_id
2073: AND organization_id = p_organization_id
2074: AND msi.buyer_id = he.employee_id;
2075:

Line 2143: FROM mtl_system_items

2139: v_uom_code VARCHAR2(3);
2140: BEGIN
2141:
2142: SELECT primary_uom_code INTO v_uom_code
2143: FROM mtl_system_items
2144: WHERE inventory_item_id = p_inventory_item_id
2145: AND organization_id = p_organization_id;
2146:
2147: RETURN v_uom_code;