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 320: po_line_locations pll

316: SELECT 'N'
317: INTO l_allow_cancel
318: FROM ap_invoice_distributions AID,
319: po_distributions PD,
320: po_line_locations pll
321: WHERE aid.invoice_id = p_invoice_id
322: --AND aid.final_match_flag in ('N','Y') For Bug 3489536
323: AND aid.po_distribution_id = pd.po_distribution_id
324: AND pll.line_location_id = pd.line_location_id

Line 341: po_line_locations pll,

337:
338: SELECT count(distinct pll.line_location_id)
339: INTO l_final_closed_shipment_count
340: FROM ap_invoice_distributions aid,
341: po_line_locations pll,
342: po_distributions pd
343: WHERE aid.invoice_id = p_invoice_id
344: AND aid.po_distribution_id = pd.po_distribution_id
345: AND pd.line_location_id = pll.line_location_id

Line 380: po_line_locations_ALL PL

376:
377: SELECT count(*)
378: INTO l_final_close_count
379: FROM ap_invoice_lines AIL,
380: po_line_locations_ALL PL
381: WHERE AIL.invoice_id = P_invoice_id
382: AND AIL.po_line_location_id = PL.line_location_id
383: AND AIL.org_id = PL.org_id
384: AND PL.closed_code = 'FINALLY CLOSED';