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_DISTRIBUTIONS

Line 66: po_distributions_ap_v POD,

62: -- Bug5497058
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

Line 319: po_distributions PD,

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

Line 342: po_distributions pd

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
346: --AND aid.final_match_flag = 'D' For bug 3489536

Line 465: po_distributions POD,

461:
462: select 'Y'
463: into l_po_not_approved
464: from po_headers POH,
465: po_distributions POD,
466: ap_invoice_distributions AID,
467: ap_invoices AI
468: where AI.invoice_id = AID.invoice_id
469: and AI.invoice_id = P_invoice_id