APPS.AP_APPROVAL_MATCHED_PKG dependencies on RCV_SHIPMENT_LINES

Line 281: rcv_shipment_lines RSL

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
284: AND D.invoice_line_number = p_inv_line_number
285: AND D.po_distribution_id = PD.po_distribution_id

Line 348: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;

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

Line 1341: rcv_shipment_lines RSL,

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

Line 1605: rcv_shipment_lines RSL,

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

Line 1917: rcv_shipment_lines RSL,

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,
1920: po_line_locations PLL,
1921: po_headers PH,