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

Line 67: po_line_locations PLL,

63: CURSOR qty_per_dist_negtive_count_cur IS
64: SELECT count(*)
65: FROM ap_invoice_distributions AID,
66: po_distributions_ap_v POD,
67: po_line_locations PLL,
68: po_lines PL,
69: ap_invoices AIV
70: WHERE POD.po_distribution_id = AID.po_distribution_id
71: AND POD.line_location_id = PLL.line_location_id

Line 307: po_line_locations pll

303: SELECT 'N'
304: INTO l_allow_cancel
305: FROM ap_invoice_distributions AID,
306: po_distributions PD,
307: po_line_locations pll
308: WHERE aid.invoice_id = p_invoice_id
309: --AND aid.final_match_flag in ('N','Y') For Bug 3489536
310: AND aid.po_distribution_id = pd.po_distribution_id
311: AND pll.line_location_id = pd.line_location_id

Line 328: po_line_locations pll,

324:
325: SELECT count(distinct pll.line_location_id)
326: INTO l_final_closed_shipment_count
327: FROM ap_invoice_distributions aid,
328: po_line_locations pll,
329: po_distributions pd
330: WHERE aid.invoice_id = p_invoice_id
331: AND aid.po_distribution_id = pd.po_distribution_id
332: AND pd.line_location_id = pll.line_location_id

Line 367: po_line_locations_ALL PL

363:
364: SELECT count(*)
365: INTO l_final_close_count
366: FROM ap_invoice_lines AIL,
367: po_line_locations_ALL PL
368: WHERE AIL.invoice_id = P_invoice_id
369: AND AIL.po_line_location_id = PL.line_location_id
370: AND AIL.org_id = PL.org_id
371: AND PL.closed_code = 'FINALLY CLOSED';