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.QA_PLAN_ELEMENT_API dependencies on PO_LINE_LOCATIONS

Line 2400: FROM po_line_locations

2396:
2397: -- Bug 4958763. SQL Repository Fix SQL ID: 15008958
2398: CURSOR c IS
2399: SELECT 1
2400: FROM po_line_locations
2401: WHERE po_line_id =
2402: ( SELECT po_line_id
2403: FROM po_lines
2404: WHERE line_num = x_po_line_num

Line 3752: FROM po_line_locations

3748: AND shipment_num like :3';
3749: */
3750: -- Bug 4958763. SQL Repository Fix SQL ID: 15009194
3751: sql_string := 'SELECT shipment_num, shipment_type
3752: FROM po_line_locations
3753: WHERE po_line_id =
3754: (SELECT po_line_id
3755: FROM po_lines
3756: WHERE line_num = :1

Line 5213: po_line_locations_all pll,

5209:
5210: CURSOR C1 IS
5211: SELECT (pll.quantity_received - (pll.quantity_accepted + pll.quantity_rejected)) quantity_received
5212: FROM po_headers_all ph,
5213: po_line_locations_all pll,
5214: po_lines_all pl
5215: WHERE pll.po_header_id = ph.po_header_id
5216: AND pll.po_line_id = pl.po_line_id
5217: AND pll.shipment_num = p_ship_num