APPS.AP_RECT_MATCH_PKG dependencies on RCV_TRANSACTIONS

Line 522: rcv_transactions rcv

518: -1 * l_retained_amount
519: FROM ap_invoice_distributions aid,
520: po_distributions pd,
521: po_line_locations pll,
522: rcv_transactions rcv
523: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
524: AND pd.po_distribution_id = aid.po_distribution_id
525: AND pll.line_location_id = pd.line_location_id
526: AND rcv.po_line_location_id = pll.line_location_id

Line 589: rcv_transactions rcv

585: l_retained_amount,
586: -1 * l_retained_amount
587: FROM ap_invoice_lines ail1,
588: po_line_locations pll,
589: rcv_transactions rcv
590: WHERE ail1.invoice_id = x_invoice_id
591: AND ail1.line_number =x_invoice_line_number
592: AND pll.line_location_id = ail1.po_line_location_id
593: AND rcv.po_line_location_id = pll.line_location_id

Line 1003: rcv_transactions RT

999: DECODE(PD.destination_type_code,
1000: 'EXPENSE', PD.award_id), --award_id
1001: ap_invoice_distributions_s.nextval
1002: FROM po_distributions_ap_v PD,
1003: rcv_transactions RT
1004: WHERE PD.line_location_id = x_po_line_location_id
1005: and Pd.line_location_id = RT.po_line_location_id
1006: and RT.TRANSACTION_ID= X_Rcv_Transaction_Id;
1007:

Line 1698: --Quantity_Billed should be selected from rcv_transactions

1694: X_matching_case := 'O';
1695: End if;
1696:
1697: --For the case of RTS debit memos:
1698: --Quantity_Billed should be selected from rcv_transactions
1699: --only when the invoice is matched to a receipt and from
1700: --po_line_locations when the invoice is matched to a PO.
1701:
1702: IF X_Match_Quantity < 0 THEN

Line 2153: RCV_TRANSACTIONS RT --for 7015553

2149: FROM PO_DISTRIBUTIONS_AP_V PD,
2150: MTL_SYSTEM_ITEMS MSI,
2151: PO_AP_RECEIPT_MATCH_V RCV,
2152: RCV_SHIPMENT_LINES RSL,
2153: RCV_TRANSACTIONS RT --for 7015553
2154: WHERE RCV.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID
2155: AND RCV.PO_LINE_LOCATION_ID = PD.LINE_LOCATION_ID
2156: AND RSL.SHIPMENT_LINE_ID = RCV.RCV_SHIPMENT_LINE_ID
2157: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)

Line 3119: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(

3115: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3116: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3117: END IF;
3118:
3119: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
3120: X_rcv_transaction_id => x_rcv_transaction_id,
3121: X_quantity_billed => x_match_quantity,
3122: X_uom_lookup_code => x_uom_lookup_code,
3123: X_amount_billed => x_match_amount,