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 306: po_distributions PD,

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

Line 329: po_distributions pd

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

Line 452: po_distributions POD,

448:
449: select 'Y'
450: into l_po_not_approved
451: from po_headers POH,
452: po_distributions POD,
453: ap_invoice_distributions AID,
454: ap_invoices AI
455: where AI.invoice_id = AID.invoice_id
456: and AI.invoice_id = P_invoice_id