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_APPROVAL_MATCHED_PKG dependencies on PO_LINES

Line 301: po_lines PL,

297: FROM ap_invoice_distributions D,
298: ap_invoices I,
299: po_distributions PD,
300: po_line_locations PLL,
301: po_lines PL,
302: rcv_transactions RTXN,
303: rcv_shipment_lines RSL,
304: ap_invoice_lines_all ail
305: WHERE I.invoice_id = p_invoice_id

Line 372: po_lines PL,

368: ap_invoices I, --retainage release invoice
369: ap_invoices retain_I, --bug 9242891 retainage invoice
370: po_distributions PD,
371: po_line_locations PLL,
372: po_lines PL,
373: rcv_transactions RTXN,
374: rcv_shipment_lines RSL
375: WHERE I.invoice_id = p_invoice_id
376: AND I.invoice_type_lookup_code = 'RETAINAGE RELEASE' --bug 9242891

Line 440: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;

436: l_amount_holder NUMBER;
437: l_erv_ccid NUMBER(15);
438: l_erv_acct_invalid_exists VARCHAR2(1) := 'N';
439: l_variance_success BOOLEAN := FALSE;
440: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
441: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
442: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
443: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;

Line 441: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;

437: l_erv_ccid NUMBER(15);
438: l_erv_acct_invalid_exists VARCHAR2(1) := 'N';
439: l_variance_success BOOLEAN := FALSE;
440: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
441: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
442: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
443: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;

Line 1561: po_lines PL,

1557: FROM ap_invoice_distributions D,
1558: po_distributions_ap_v PD,
1559: rcv_transactions RTXN,
1560: rcv_shipment_lines RSL,
1561: po_lines PL,
1562: po_line_locations PLL
1563: WHERE D.invoice_id = p_invoice_id
1564: AND D.po_distribution_id = PD.po_distribution_id
1565: AND NVL(D.match_status_flag, 'N') IN ('N', 'S', 'A')

Line 1834: po_lines PL,

1830: FROM ap_invoice_distributions D,
1831: po_distributions_ap_v PD,
1832: rcv_transactions RTXN,
1833: rcv_shipment_lines RSL,
1834: po_lines PL,
1835: po_line_locations PLL
1836: WHERE D.invoice_id = p_invoice_id
1837: AND D.po_distribution_id = PD.po_distribution_id
1838: AND NVL(D.match_status_flag, 'N') IN ('N', 'S', 'A')

Line 2143: FROM po_lines PL,

2139: --bugfix:4709926 added the NVL condition
2140: nvl(PLL.payment_type,'DUMMY'),-- Contract Payments: Tolerances Redesign
2141: I.invoice_type_lookup_code, --Contract Payments: Tolerances Redesign
2142: I.org_id -- Bug 5500101
2143: FROM po_lines PL,
2144: rcv_transactions RTXN,
2145: rcv_shipment_lines RSL,
2146: ap_invoice_lines L,
2147: ap_invoices I,