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 295: x_select := x_select || ' mtl_parameters mpa, ';

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

Line 584: FROM MTL_PARAMETERS mtl,

580: AND nvl(ol.source_document_type_id, 0) <> 10 ;
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

Line 606: FROM MTL_PARAMETERS mtl,

602:
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

Line 627: FROM MTL_PARAMETERS mtl,

623: AND po.requisition_header_id = G_doc_id ;
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

Line 650: FROM MTL_PARAMETERS mtl,

646: AND po.po_header_id = G_doc_id
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

Line 669: FROM MTL_PARAMETERS mtl,

665: AND po.shipment_header_id = G_doc_id ;
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

Line 791: ' mtl_parameters mp, '||

787: ' gmd.material_detail_id line_id, mp.organization_code inv_org_code'||
788: ' FROM '||
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 '||

Line 833: ' mtl_parameters org '||

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 '||
834: ' WHERE '||
835: ' mtl.inventory_item_id = TO_CHAR(:item_id) '||
836: ' AND hou.organization_id = org.organization_id '||
837: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||

Line 894: ' mtl_parameters mp '||

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) '||
897: ' AND psf.organization_id = TO_CHAR(:organization_id) '||
898: ' AND hou.organization_id = mp.organization_id '||

Line 930: ' FROM MTL_PARAMETERS mtl, '||

926: ' NULL)) trans_qty2, '||
927: -- Modified line_id from po.line_location_id to po.po_line_id as per bug # 11068148
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 '||

Line 962: ' FROM MTL_PARAMETERS mtl, '||

958: ' mitem.secondary_uom_code, '||
959: ' NULL, '||
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 '||

Line 994: ' FROM MTL_PARAMETERS mtl, '||

990: ' mitem.secondary_uom_code, '||
991: ' NULL, '||
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 '||

Line 1026: ' FROM MTL_PARAMETERS mtl, '||

1022: ' mitem.secondary_uom_code, '||
1023: ' NULL, '||
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 '||

Line 1054: ' FROM MTL_PARAMETERS mtl, '||

1050: ' mitem.secondary_uom_code, '||
1051: ' NULL, '||
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 '||

Line 1532: FROM MTL_PARAMETERS mtl,

1528: CURSOR Cur_purchase_details IS
1529: --Modified to vendor_name from segment1 as per bug # 11068148
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

Line 1557: FROM MTL_PARAMETERS mtl,

1553: CURSOR Cur_receiving_details IS
1554: --Modified to vendor_name from segment1 as per bug # 11068148
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

Line 1582: FROM MTL_PARAMETERS mtl,

1578: UNION ALL
1579: --Modified to vendor_name from segment1 as per bug # 11068148
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,

Line 1605: FROM MTL_PARAMETERS mtl,

1601: CURSOR Cur_shipment_details IS
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,

Line 1627: FROM MTL_PARAMETERS mtl,

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

Line 2013: FROM mtl_parameters

2009: v_org_code VARCHAR2(3);
2010: BEGIN
2011:
2012: SELECT organization_code INTO v_org_code
2013: FROM mtl_parameters
2014: WHERE organization_id = p_organization_id;
2015:
2016: RETURN v_org_code;
2017: