APPS.AP_APPROVAL_MATCHED_PKG dependencies on RCV_SHIPMENT_LINES

Line 303: rcv_shipment_lines RSL,

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
306: AND I.invoice_id = D.invoice_id
307: AND D.invoice_line_number = p_inv_line_number

Line 374: rcv_shipment_lines RSL

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
377: AND I.invoice_id = D.invoice_id
378: AND D.retained_invoice_dist_id = retain_D.Invoice_Distribution_Id --bug 9242891

Line 444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;

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;
446: l_uom_conv_rate NUMBER := NULL;
447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
448: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;

Line 1560: rcv_shipment_lines RSL,

1556: ,PLL.match_option -- l_match_option
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

Line 1833: rcv_shipment_lines RSL,

1829: ,PLL.match_option -- l_match_option
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

Line 2145: rcv_shipment_lines RSL,

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,
2148: po_line_locations PLL,
2149: po_headers PH,