eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_RCT_AMT_MATCH_PKG dependencies on RCV_TRANSACTIONS

Line 570: rcv_transactions rtxn -- bug 5443250

566: -1 * l_retained_amount
567: FROM ap_invoice_distributions aid,
568: po_distributions pd,
569: po_line_locations pll,
570: rcv_transactions rtxn -- bug 5443250
571: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
572: AND pd.po_distribution_id = aid.po_distribution_id
573: AND pll.line_location_id = pd.line_location_id
574: AND rtxn.po_line_location_id = pll.line_location_id

Line 633: rcv_transactions rtxn -- bug 5443250

629: l_retained_amount,
630: -1 * l_retained_amount
631: FROM ap_invoice_lines ail1,
632: po_line_locations pll,
633: rcv_transactions rtxn -- bug 5443250
634: WHERE ail1.invoice_id = x_invoice_id
635: AND ail1.line_number =x_invoice_line_number
636: AND pll.line_location_id = ail1.po_line_location_id
637: AND rtxn.po_line_location_id = pll.line_location_id

Line 1032: rcv_transactions RT

1028: DECODE(PD.destination_type_code,
1029: 'EXPENSE', PD.award_id), --award_id
1030: ap_invoice_distributions_s.nextval
1031: FROM po_distributions_ap_v PD,
1032: rcv_transactions RT
1033: WHERE PD.line_location_id = x_po_line_location_id
1034: and Pd.line_location_id = RT.po_line_location_id
1035: and Pd.po_distribution_id = NVL(RT.po_distribution_id, Pd.po_distribution_id) --Added for bug 13845471
1036: and RT.TRANSACTION_ID= X_Rcv_Transaction_Id ;

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

1265: x_dist_tab(i).expenditure_item_date,
1266: x_dist_tab(i).expenditure_organization_id,
1267: x_dist_tab(i).invoice_distribution_id
1268: FROM po_distributions_ap_v pod
1269: ,rcv_transactions RT --Added for bug 13845471
1270: WHERE pod.po_distribution_id = x_dist_tab(i).po_distribution_id
1271: AND pod.po_distribution_id = NVL(rt.po_distribution_id,pod.po_distribution_id) --Added for bug 13845471
1272: AND rt.TRANSACTION_ID= X_Rcv_Transaction_Id; --Added for bug 13845471
1273:

Line 1872: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(

1868:
1869: l_debug_info := 'Call RCV api to update amount/quantity billed on the
1870: rcv_transaction';
1871:
1872: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
1873: X_rcv_transaction_id => x_rcv_transaction_id,
1874: X_quantity_billed => Null,
1875: X_uom_lookup_code => x_uom_lookup_code,
1876: X_amount_billed => x_match_amount,

Line 2281: RCV_TRANSACTIONS RT --7015553

2277: FROM PO_DISTRIBUTIONS_AP_V PD,
2278: MTL_SYSTEM_ITEMS MSI,
2279: PO_AP_RECEIPT_MATCH_V RCV,
2280: RCV_SHIPMENT_LINES RSL,
2281: RCV_TRANSACTIONS RT --7015553
2282: WHERE RCV.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID
2283: AND RCV.PO_LINE_LOCATION_ID = PD.LINE_LOCATION_ID
2284: AND RSL.SHIPMENT_LINE_ID = RCV.RCV_SHIPMENT_LINE_ID
2285: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)