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.GMPMRACT dependencies on PO_PO_SUPPLY_VIEW

Line 1026: # po_po_supply_view so that releases are shown for 'PORD' doc_type.

1022: # P.Raghu 12/26/03 - B2131275 - Modified Cur_vend_dtl and Cur_req_dtl cursors
1023: # to select vendor_name and suggested_vendor_name instead of
1024: # segment1 value for Customer/Vendor respectively.
1025: # Sastry 04/01/2004 - B3482123 - Replaced po_headers_all table with
1026: # po_po_supply_view so that releases are shown for 'PORD' doc_type.
1027: #############################################################################*/
1028: PROCEDURE mr_cleanup_details IS
1029: CURSOR Cur_custno IS
1030: SELECT cs.cust_no cust_no

Line 1037: --BUG#3482123 Sastry Replaced po_headers_all table with po_po_supply_view.

1033: AND dt.shipcust_id = cs.cust_id;
1034:
1035: --Bug#2131275 P.Raghu
1036: --Selecting pv.vendor_name instead of pv.segment1 value for Customer/Vendor.
1037: --BUG#3482123 Sastry Replaced po_headers_all table with po_po_supply_view.
1038: CURSOR Cur_vend_dtl IS
1039: SELECT unique mtt.orgn_code, po.po_number, SUBSTRB(vn.vendor_name,1,32)
1040: FROM po_po_supply_view po,
1041: po_vendors vn,

Line 1040: FROM po_po_supply_view po,

1036: --Selecting pv.vendor_name instead of pv.segment1 value for Customer/Vendor.
1037: --BUG#3482123 Sastry Replaced po_headers_all table with po_po_supply_view.
1038: CURSOR Cur_vend_dtl IS
1039: SELECT unique mtt.orgn_code, po.po_number, SUBSTRB(vn.vendor_name,1,32)
1040: FROM po_po_supply_view po,
1041: po_vendors vn,
1042: mr_tran_tbl mtt
1043: WHERE po.po_line_location_id = mtt.doc_id
1044: AND mtt.mrp_id = G_mrp_id