[Home] [Help]
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
284: AND D.invoice_line_number = p_inv_line_number
403:
404: BEGIN
405: SELECT 'Y'
406: INTO l_lcm_enabled
407: FROM RCV_TRANSACTIONS
408: WHERE TRANSACTION_ID = l_rcv_transaction_id
409: AND LCM_SHIPMENT_LINE_ID IS NOT NULL;
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN NULL;
1336: ,PL.unit_meas_lookup_code -- l_po_uom
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
1600: - nvl(PD.amount_cancelled,0) -- l_po_amt
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
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,
1920: po_line_locations PLL,
4110: IF (p_match_option = 'P') THEN
4111: BEGIN
4112: SELECT count(*)
4113: INTO l_rec_exception_count
4114: FROM rcv_transactions rt,
4115: ap_invoice_lines ail
4116: WHERE rt.receipt_exception_flag = 'Y'
4117: AND rt.transaction_type = 'RECEIVE'
4118: AND rt.po_line_location_id = ail.po_line_location_id
4129: ELSIF (p_match_option = 'R') THEN
4130: BEGIN
4131: SELECT 'Y'
4132: INTO l_rec_exception_exists
4133: FROM rcv_transactions rtxn
4134: WHERE rtxn.transaction_id = p_rcv_transaction_id
4135: AND rtxn.receipt_exception_flag = 'Y';
4136:
4137: EXCEPTION