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 1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;

1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:
1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1447: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;

Line 1552: po_line_types_b plt --bug 5056269

1548: plt.matching_basis
1549: FROM AP_invoice_lines ail,
1550: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
1551: po_line_locations pll,
1552: po_line_types_b plt --bug 5056269
1553: -- po_line_types_tl T --bug 5119694
1554: WHERE invoice_id = CV_PPAY_Invoice_ID
1555: AND line_number = CV_PPAY_LINE_NUM
1556: AND ail.po_line_location_id = pll.line_location_id(+)

Line 1553: -- po_line_types_tl T --bug 5119694

1549: FROM AP_invoice_lines ail,
1550: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
1551: po_line_locations pll,
1552: po_line_types_b plt --bug 5056269
1553: -- po_line_types_tl T --bug 5119694
1554: WHERE invoice_id = CV_PPAY_Invoice_ID
1555: AND line_number = CV_PPAY_LINE_NUM
1556: AND ail.po_line_location_id = pll.line_location_id(+)
1557: AND pll.po_line_id = pl.po_line_id(+)

Line 4033: po_line_types_b plt, --bug 5056269

4029: FROM ap_invoice_distributions aid,
4030: ap_invoice_lines ail,
4031: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4032: po_line_locations pll,
4033: po_line_types_b plt, --bug 5056269
4034: po_line_types_tl T
4035: WHERE aid.invoice_id = ail.invoice_id
4036: AND aid.invoice_line_number = ail.line_number
4037: AND aid.invoice_id = p_invoice_id

Line 4034: po_line_types_tl T

4030: ap_invoice_lines ail,
4031: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4032: po_line_locations pll,
4033: po_line_types_b plt, --bug 5056269
4034: po_line_types_tl T
4035: WHERE aid.invoice_id = ail.invoice_id
4036: AND aid.invoice_line_number = ail.line_number
4037: AND aid.invoice_id = p_invoice_id
4038: AND aid.invoice_line_number = p_invoice_line_num