APPS.AP_RECT_MATCH_PKG dependencies on RCV_TRANSACTIONS

Line 611: rcv_transactions rcv

607: -1 * l_retained_amount
608: FROM ap_invoice_distributions aid,
609: po_distributions pd,
610: po_line_locations pll,
611: rcv_transactions rcv
612: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
613: AND pd.po_distribution_id = aid.po_distribution_id
614: AND pll.line_location_id = pd.line_location_id
615: AND rcv.po_line_location_id = pll.line_location_id

Line 678: rcv_transactions rcv

674: l_retained_amount,
675: -1 * l_retained_amount
676: FROM ap_invoice_lines ail1,
677: po_line_locations pll,
678: rcv_transactions rcv
679: WHERE ail1.invoice_id = x_invoice_id
680: AND ail1.line_number =x_invoice_line_number
681: AND pll.line_location_id = ail1.po_line_location_id
682: AND rcv.po_line_location_id = pll.line_location_id

Line 1102: rcv_transactions RT

1098: DECODE(PD.destination_type_code,
1099: 'EXPENSE', PD.award_id), --award_id
1100: ap_invoice_distributions_s.nextval
1101: FROM po_distributions_ap_v PD,
1102: rcv_transactions RT
1103: WHERE PD.line_location_id = x_po_line_location_id
1104: and Pd.line_location_id = RT.po_line_location_id
1105: and Pd.po_distribution_id = NVL(RT.po_distribution_id, Pd.po_distribution_id) -- bug 8771037
1106: and RT.TRANSACTION_ID= X_Rcv_Transaction_Id;

Line 1407: ,rcv_transactions RT --Added for bug 13845471

1403: x_dist_tab(i).expenditure_item_date,
1404: x_dist_tab(i).expenditure_organization_id,
1405: x_dist_tab(i).invoice_distribution_id
1406: FROM po_distributions_ap_v pd
1407: ,rcv_transactions RT --Added for bug 13845471
1408: WHERE pd.po_distribution_id = x_dist_tab(i).po_distribution_id
1409: AND pd.po_distribution_id = NVL(rt.po_distribution_id,pd.po_distribution_id) --Added for bug 13845471
1410: AND rt.TRANSACTION_ID= X_Rcv_Transaction_Id; --Added for bug 13845471
1411:

Line 1840: --Quantity_Billed should be selected from rcv_transactions

1836: X_matching_case := 'O';
1837: End if;
1838:
1839: --For the case of RTS debit memos:
1840: --Quantity_Billed should be selected from rcv_transactions
1841: --only when the invoice is matched to a receipt and from
1842: --po_line_locations when the invoice is matched to a PO.
1843:
1844: IF X_Match_Quantity < 0 THEN

Line 2326: RCV_TRANSACTIONS RT --for 7015553

2322: FROM PO_DISTRIBUTIONS_AP_V PD,
2323: MTL_SYSTEM_ITEMS MSI,
2324: PO_AP_RECEIPT_MATCH_V RCV,
2325: RCV_SHIPMENT_LINES RSL,
2326: RCV_TRANSACTIONS RT --for 7015553
2327: WHERE RCV.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID
2328: AND RCV.PO_LINE_LOCATION_ID = PD.LINE_LOCATION_ID
2329: AND RSL.SHIPMENT_LINE_ID = RCV.RCV_SHIPMENT_LINE_ID
2330: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)

Line 3327: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(

3323: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3325: END IF;
3326:
3327: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
3328: X_rcv_transaction_id => x_rcv_transaction_id,
3329: X_quantity_billed => x_match_quantity,
3330: X_uom_lookup_code => x_uom_lookup_code,
3331: X_amount_billed => x_match_amount,