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_PARAMETERS

Line 293: x_select := x_select || ' mtl_parameters mpa, ';

289: IF G_fbuyer IS NOT NULL OR G_tbuyer IS NOT NULL THEN
290: x_select := x_select || ' hr_employees hem, ';
291: END IF;
292: IF G_forg IS NOT NULL OR G_torg IS NOT NULL THEN
293: x_select := x_select || ' mtl_parameters mpa, ';
294: END IF;
295: IF G_fcategory IS NOT NULL OR G_tcategory IS NOT NULL THEN
296: x_select := x_select || ' mtl_categories_kfv mca, ';
297: END IF;

Line 582: FROM MTL_PARAMETERS mtl,

578: AND nvl(ol.source_document_type_id, 0) <> 10 ;
579:
580: CURSOR Cur_po_doc_no IS
581: SELECT po.po_number
582: FROM MTL_PARAMETERS mtl,
583: MTL_SYSTEM_ITEMS mitem,
584: -- IC_ITEM_MST ic,
585: PO_PO_SUPPLY_VIEW po
586: WHERE po.item_id = mitem.inventory_item_id

Line 604: FROM MTL_PARAMETERS mtl,

600:
601:
602: CURSOR Cur_requisition_details IS
603: SELECT po.requisition_number
604: FROM MTL_PARAMETERS mtl,
605: MTL_SYSTEM_ITEMS mitem,
606: -- IC_ITEM_MST ic,
607: PO_REQ_SUPPLY_VIEW po
608: WHERE po.item_id = mitem.inventory_item_id

Line 625: FROM MTL_PARAMETERS mtl,

621: AND po.requisition_header_id = G_doc_id ;
622:
623: CURSOR Cur_receiving_details IS
624: SELECT ph.segment1
625: FROM MTL_PARAMETERS mtl,
626: MTL_SYSTEM_ITEMS mitem,
627: -- IC_ITEM_MST ic,
628: PO_HEADERS_ALL ph,
629: PO_RCV_SUPPLY_VIEW po

Line 648: FROM MTL_PARAMETERS mtl,

644: AND po.po_header_id = G_doc_id
645: AND G_doc_type = 'PRCV'
646: UNION ALL
647: SELECT rsh.receipt_num
648: FROM MTL_PARAMETERS mtl,
649: MTL_SYSTEM_ITEMS mitem,
650: -- IC_ITEM_MST ic,
651: RCV_SHIPMENT_HEADERS rsh,
652: PO_SHIP_RCV_SUPPLY_VIEW po

Line 667: FROM MTL_PARAMETERS mtl,

663: AND po.shipment_header_id = G_doc_id ;
664:
665: CURSOR Cur_shipment_details IS
666: SELECT rsh.receipt_num
667: FROM MTL_PARAMETERS mtl,
668: MTL_SYSTEM_ITEMS mitem,
669: -- IC_ITEM_MST ic,
670: RCV_SHIPMENT_HEADERS rsh,
671: PO_SHIP_SUPPLY_VIEW po

Line 789: ' mtl_parameters mp, '||

785: ' gmd.material_detail_id line_id, mp.organization_code inv_org_code'||
786: ' FROM '||
787: ' gme_batch_header gbh, '||
788: ' gme_material_details gmd, '||
789: ' mtl_parameters mp, '||
790: ' hr_organization_units hou, '||
791: ' mtl_system_items msi '||
792: ' WHERE '||
793: ' Gbh.batch_id = gmd.batch_id '||

Line 831: ' mtl_parameters org '||

827: ' mtl_system_items items, '||
828: ' oe_order_headers_all hdr, '||
829: ' oe_order_lines_all dtl, '||
830: ' hr_organization_units hou, '||
831: ' mtl_parameters org '||
832: ' WHERE '||
833: ' mtl.inventory_item_id = TO_CHAR(:item_id) '||
834: ' AND hou.organization_id = org.organization_id '||
835: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||

Line 892: ' mtl_parameters mp '||

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

Line 924: ' FROM MTL_PARAMETERS mtl, '||

920: ' mitem.secondary_uom_code, '||
921: ' NULL, '||
922: ' NULL)) trans_qty2, '||
923: ' po.po_line_location_id line_id, mtl.organization_code inv_org_code '||
924: ' FROM MTL_PARAMETERS mtl, '||
925: ' hr_organization_units hou, '||
926: ' po_po_supply_view po, mtl_system_items mitem '||
927: ' WHERE po.item_id = TO_CHAR(:item_id) '||
928: ' AND po.item_id = mitem.inventory_item_id '||

Line 956: ' FROM MTL_PARAMETERS mtl, '||

952: ' mitem.secondary_uom_code, '||
953: ' NULL, '||
954: ' NULL )) trans_qty2, '||
955: ' po.req_line_id, mtl.organization_code '||
956: ' FROM MTL_PARAMETERS mtl, '||
957: ' hr_organization_units hou, '||
958: ' po_req_supply_view po, mtl_system_items mitem '||
959: ' WHERE po.item_id = TO_CHAR(:item_id) '||
960: ' AND po.item_id = mitem.inventory_item_id '||

Line 988: ' FROM MTL_PARAMETERS mtl, '||

984: ' mitem.secondary_uom_code, '||
985: ' NULL, '||
986: ' NULL)) trans_qty2, '||
987: ' po.po_line_id line_id, mtl.organization_code inv_org_code '||
988: ' FROM MTL_PARAMETERS mtl, '||
989: ' hr_organization_units hou, '||
990: ' po_rcv_supply_view po, mtl_system_items mitem '||
991: ' WHERE po.item_id = TO_CHAR(:item_id) '||
992: ' AND po.item_id = mitem.inventory_item_id '||

Line 1020: ' FROM MTL_PARAMETERS mtl, '||

1016: ' mitem.secondary_uom_code, '||
1017: ' NULL, '||
1018: ' NULL)) trans_qty2, '||
1019: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1020: ' FROM MTL_PARAMETERS mtl, '||
1021: ' hr_organization_units hou, '||
1022: ' po_ship_rcv_supply_view po, mtl_system_items mitem '||
1023: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1024: ' AND po.item_id = mitem.inventory_item_id '||

Line 1048: ' FROM MTL_PARAMETERS mtl, '||

1044: ' mitem.secondary_uom_code, '||
1045: ' NULL, '||
1046: ' NULL)) trans_qty2, '||
1047: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1048: ' FROM MTL_PARAMETERS mtl, '||
1049: ' hr_organization_units hou, '||
1050: ' po_ship_supply_view po, mtl_system_items mitem '||
1051: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1052: ' AND po.item_id = mitem.inventory_item_id '||

Line 1524: FROM MTL_PARAMETERS mtl,

1520: /* nsinghi MPSCONV End */
1521:
1522: CURSOR Cur_purchase_details IS
1523: SELECT UNIQUE pv.segment1
1524: FROM MTL_PARAMETERS mtl,
1525: PO_VENDORS pv,
1526: MTL_SYSTEM_ITEMS mitem,
1527: -- IC_ITEM_MST ic,
1528: PO_PO_SUPPLY_VIEW po

Line 1547: FROM MTL_PARAMETERS mtl,

1543: AND po.po_line_id = G_tranline_id ;
1544:
1545: CURSOR Cur_receiving_details IS
1546: SELECT UNIQUE pv.segment1
1547: FROM MTL_PARAMETERS mtl,
1548: PO_VENDORS pv,
1549: MTL_SYSTEM_ITEMS mitem,
1550: -- IC_ITEM_MST ic,
1551: PO_RCV_SUPPLY_VIEW po

Line 1570: FROM MTL_PARAMETERS mtl,

1566: AND po.po_line_id = G_tranline_id
1567: AND G_doc_type = 'PRCV'
1568: UNION ALL
1569: SELECT UNIQUE pv.segment1
1570: FROM MTL_PARAMETERS mtl,
1571: PO_VENDORS pv,
1572: MTL_SYSTEM_ITEMS mitem,
1573: -- IC_ITEM_MST ic,
1574: RCV_SHIPMENT_HEADERS rsh,

Line 1591: FROM MTL_PARAMETERS mtl,

1587: AND po.shipment_line_id = G_tranline_id ;
1588:
1589: CURSOR Cur_shipment_details IS
1590: SELECT UNIQUE pv.segment1
1591: FROM MTL_PARAMETERS mtl,
1592: MTL_SYSTEM_ITEMS mitem,
1593: -- IC_ITEM_MST ic,
1594: PO_VENDORS pv,
1595: RCV_SHIPMENT_HEADERS rsh,

Line 1613: FROM MTL_PARAMETERS mtl,

1609:
1610:
1611: CURSOR Cur_requisition_details IS
1612: SELECT SUBSTRB(prl.suggested_vendor_name,1,40)
1613: FROM MTL_PARAMETERS mtl,
1614: MTL_SYSTEM_ITEMS mitem,
1615: -- IC_ITEM_MST ic,
1616: -- IC_WHSE_MST iwm,
1617: PO_REQUISITION_LINES_ALL prl,

Line 1951: FROM mtl_parameters

1947: v_org_code VARCHAR2(3);
1948: BEGIN
1949:
1950: SELECT organization_code INTO v_org_code
1951: FROM mtl_parameters
1952: WHERE organization_id = p_organization_id;
1953:
1954: RETURN v_org_code;
1955: