APPS.AP_APPROVAL_MATCHED_PKG dependencies on RCV_TRANSACTIONS

Line 302: rcv_transactions RTXN,

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

Line 373: rcv_transactions RTXN,

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
377: AND I.invoice_id = D.invoice_id

Line 511: FROM RCV_TRANSACTIONS

507:
508: BEGIN
509: SELECT 'Y'
510: INTO l_lcm_enabled
511: FROM RCV_TRANSACTIONS
512: WHERE TRANSACTION_ID = l_rcv_transaction_id
513: AND LCM_SHIPMENT_LINE_ID IS NOT NULL;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN NULL;

Line 1559: rcv_transactions RTXN,

1555: ,PL.unit_meas_lookup_code -- l_po_uom
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

Line 1832: rcv_transactions RTXN,

1828: - nvl(PD.amount_cancelled,0) -- l_po_amt
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

Line 2144: rcv_transactions RTXN,

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

Line 4557: FROM rcv_transactions rt,

4553: IF (p_match_option = 'P') THEN
4554: BEGIN
4555: SELECT count(*)
4556: INTO l_rec_exception_count
4557: FROM rcv_transactions rt,
4558: ap_invoice_lines ail
4559: WHERE rt.receipt_exception_flag = 'Y'
4560: AND rt.transaction_type = 'RECEIVE'
4561: AND rt.po_line_location_id = ail.po_line_location_id

Line 4576: FROM rcv_transactions rtxn

4572: ELSIF (p_match_option = 'R') THEN
4573: BEGIN
4574: SELECT 'Y'
4575: INTO l_rec_exception_exists
4576: FROM rcv_transactions rtxn
4577: WHERE rtxn.transaction_id = p_rcv_transaction_id
4578: AND rtxn.receipt_exception_flag = 'Y';
4579:
4580: EXCEPTION

Line 6031: FROM rcv_transactions RT

6027: /*Bug:14726598 Start*/
6028: ELSE /* Bug: 14726598:Following code is added to fetch PO Base Amount for reciept matched invoices based on exchange rate of reciepts for quantity type po match */
6029: SELECT SUM((NVL(RT.quantity, 0)) * p_po_price* DECODE(p_inv_curr_code, p_base_curr_code,1,RT.currency_conversion_rate))
6030: INTO rcv_total
6031: FROM rcv_transactions RT
6032: WHERE RT.transaction_id=p_rcv_transaction_id;
6033:
6034: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6035: INTO p_ship_base_amt_var

Line 6039: ,rcv_transactions RT

6035: INTO p_ship_base_amt_var
6036: FROM ap_invoice_distributions D
6037: , ap_invoices I
6038: , ap_invoice_lines L
6039: ,rcv_transactions RT
6040: WHERE D.rcv_transaction_id = RT.transaction_id
6041: AND RT.transaction_id=p_rcv_transaction_id
6042: AND D.invoice_id = I.invoice_id
6043: AND L.invoice_id = I.invoice_id --Bug6824860

Line 6089: FROM rcv_transactions RT

6085: /*Bug:14726598 Start*/
6086: ELSE /* Bug: 14726598:Following code is added to fetch PO Base Amount for reciept matched invoices based on exchange rate of reciepts for amount type po match */
6087: SELECT SUM((NVL(RT.amount, 0)) * DECODE(p_inv_curr_code, p_base_curr_code,1,RT.currency_conversion_rate))
6088: INTO rcv_total
6089: FROM rcv_transactions RT
6090: WHERE RT.transaction_id=p_rcv_transaction_id;
6091:
6092: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6093: INTO p_ship_base_amt_var

Line 6097: ,rcv_transactions RT

6093: INTO p_ship_base_amt_var
6094: FROM ap_invoice_distributions D
6095: , ap_invoices I
6096: , ap_invoice_lines L
6097: ,rcv_transactions RT
6098: WHERE D.rcv_transaction_id = RT.transaction_id
6099: AND RT.transaction_id=p_rcv_transaction_id
6100: AND D.invoice_id = I.invoice_id
6101: AND L.invoice_id = I.invoice_id --Bug6824860