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.

[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on PO_LINES

Line 279: po_lines PL,

275: FROM ap_invoice_distributions D,
276: ap_invoices I,
277: po_distributions PD,
278: po_line_locations PLL,
279: po_lines PL,
280: rcv_transactions RTXN,
281: rcv_shipment_lines RSL
282: WHERE I.invoice_id = p_invoice_id
283: AND I.invoice_id = D.invoice_id

Line 344: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;

340: l_amount_holder NUMBER;
341: l_erv_ccid NUMBER(15);
342: l_erv_acct_invalid_exists VARCHAR2(1) := 'N';
343: l_variance_success BOOLEAN := FALSE;
344: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
345: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
346: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
347: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
348: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;

Line 345: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;

341: l_erv_ccid NUMBER(15);
342: l_erv_acct_invalid_exists VARCHAR2(1) := 'N';
343: l_variance_success BOOLEAN := FALSE;
344: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
345: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
346: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
347: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
348: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
349: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;

Line 1342: po_lines PL,

1338: FROM ap_invoice_distributions D,
1339: po_distributions_ap_v PD,
1340: rcv_transactions RTXN,
1341: rcv_shipment_lines RSL,
1342: po_lines PL,
1343: po_line_locations PLL
1344: WHERE D.invoice_id = p_invoice_id
1345: AND D.po_distribution_id = PD.po_distribution_id
1346: AND NVL(D.match_status_flag, 'N') IN ('N', 'S', 'A')

Line 1606: po_lines PL,

1602: FROM ap_invoice_distributions D,
1603: po_distributions_ap_v PD,
1604: rcv_transactions RTXN,
1605: rcv_shipment_lines RSL,
1606: po_lines PL,
1607: po_line_locations PLL
1608: WHERE D.invoice_id = p_invoice_id
1609: AND D.po_distribution_id = PD.po_distribution_id
1610: AND NVL(D.match_status_flag, 'N') IN ('N', 'S', 'A')

Line 1915: FROM po_lines PL,

1911: --bugfix:4709926 added the NVL condition
1912: nvl(PLL.payment_type,'DUMMY'),-- Contract Payments: Tolerances Redesign
1913: I.invoice_type_lookup_code, --Contract Payments: Tolerances Redesign
1914: I.org_id -- Bug 5500101
1915: FROM po_lines PL,
1916: rcv_transactions RTXN,
1917: rcv_shipment_lines RSL,
1918: ap_invoice_lines L,
1919: ap_invoices I,