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_PREPAY_PKG dependencies on PO_LINE_TYPES

Line 1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;

1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:
1467: -- Prepayment Payment Related Variables
1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1469: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;

Line 1578: po_line_types_b plt --bug 5056269

1574: plt.matching_basis
1575: FROM AP_invoice_lines ail,
1576: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
1577: po_line_locations pll,
1578: po_line_types_b plt --bug 5056269
1579: -- po_line_types_tl T --bug 5119694
1580: WHERE invoice_id = CV_PPAY_Invoice_ID
1581: AND line_number = CV_PPAY_LINE_NUM
1582: AND ail.po_line_location_id = pll.line_location_id(+)

Line 1579: -- po_line_types_tl T --bug 5119694

1575: FROM AP_invoice_lines ail,
1576: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
1577: po_line_locations pll,
1578: po_line_types_b plt --bug 5056269
1579: -- po_line_types_tl T --bug 5119694
1580: WHERE invoice_id = CV_PPAY_Invoice_ID
1581: AND line_number = CV_PPAY_LINE_NUM
1582: AND ail.po_line_location_id = pll.line_location_id(+)
1583: AND pll.po_line_id = pl.po_line_id(+)

Line 4199: po_line_types_b plt, --bug 5056269

4195: FROM ap_invoice_distributions aid,
4196: ap_invoice_lines ail,
4197: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4198: po_line_locations pll,
4199: po_line_types_b plt, --bug 5056269
4200: po_line_types_tl T
4201: WHERE aid.invoice_id = ail.invoice_id
4202: AND aid.invoice_line_number = ail.line_number
4203: AND aid.invoice_id = p_invoice_id

Line 4200: po_line_types_tl T

4196: ap_invoice_lines ail,
4197: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4198: po_line_locations pll,
4199: po_line_types_b plt, --bug 5056269
4200: po_line_types_tl T
4201: WHERE aid.invoice_id = ail.invoice_id
4202: AND aid.invoice_line_number = ail.line_number
4203: AND aid.invoice_id = p_invoice_id
4204: AND aid.invoice_line_number = p_invoice_line_num