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_AUTO_DM_CREATION_PKG dependencies on RCV_TRANSACTIONS

Line 180: l_vendor_id rcv_transactions.vendor_id%TYPE;

176: p_login_id IN NUMBER,
177: p_calling_sequence IN VARCHAR2)
178: RETURN BOOLEAN IS
179:
180: l_vendor_id rcv_transactions.vendor_id%TYPE;
181: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;
183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;

Line 181: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;

177: p_calling_sequence IN VARCHAR2)
178: RETURN BOOLEAN IS
179:
180: l_vendor_id rcv_transactions.vendor_id%TYPE;
181: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;
183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;

Line 182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;

178: RETURN BOOLEAN IS
179:
180: l_vendor_id rcv_transactions.vendor_id%TYPE;
181: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;
183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;
186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;

Line 183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;

179:
180: l_vendor_id rcv_transactions.vendor_id%TYPE;
181: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;
183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;
186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;
187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;

Line 184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;

180: l_vendor_id rcv_transactions.vendor_id%TYPE;
181: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;
183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;
186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;
187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;
188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

Line 185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;

181: l_vendor_site_id rcv_transactions.vendor_site_id%TYPE;
182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;
183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;
186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;
187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;
188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;

Line 186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;

182: l_rcv_currency_code rcv_transactions.currency_code%TYPE;
183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;
186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;
187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;
188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;
190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;

Line 187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;

183: l_po_shipment_id rcv_transactions.po_line_location_id%TYPE;
184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;
186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;
187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;
188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;
190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;
191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;

Line 235: l_rts_txn_date rcv_transactions.transaction_date%TYPE;

231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;
232:
233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;
234: l_batch_id ap_batches.batch_id%TYPE;
235: l_rts_txn_date rcv_transactions.transaction_date%TYPE;
236: l_rcv_quantity_billed rcv_transactions.quantity_billed%TYPE;
237: l_invoice_id ap_invoices.invoice_id%TYPE;
238: l_amount ap_invoices.invoice_amount%TYPE;
239: l_terms_date DATE;

Line 236: l_rcv_quantity_billed rcv_transactions.quantity_billed%TYPE;

232:
233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;
234: l_batch_id ap_batches.batch_id%TYPE;
235: l_rts_txn_date rcv_transactions.transaction_date%TYPE;
236: l_rcv_quantity_billed rcv_transactions.quantity_billed%TYPE;
237: l_invoice_id ap_invoices.invoice_id%TYPE;
238: l_amount ap_invoices.invoice_amount%TYPE;
239: l_terms_date DATE;
240: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;

Line 279: Retreive all required information from rcv_transactions */

275: curr_calling_sequence := p_calling_sequence ||' <- Create_DM';
276: l_invoice_exists := 'N';
277:
278: /* STEP 1:
279: Retreive all required information from rcv_transactions */
280:
281: debug_info := 'Retreive receipt information';
282:
283: --Bug fix:1413339

Line 749: GET_RECEIPT_INFO : Gets relevant information from rcv_transactions and

745:
746: /* Private Procedure/functions */
747:
748: /*-------------------------------------------------------------------------
749: GET_RECEIPT_INFO : Gets relevant information from rcv_transactions and
750: po_shipments
751: --------------------------------------------------------------------------*/
752: Procedure Get_receipt_info(
753: p_rcv_txn_id IN NUMBER,

Line 825: rcv_transactions rtxn,

821: p_match_option, --bug2902340
822: p_org_id,
823: p_po_uom
824: FROM
825: rcv_transactions rtxn,
826: rcv_shipment_headers rsh,
827: rcv_shipment_lines rsl,
828: po_headers ph,
829: po_line_locations pll,

Line 849: FROM rcv_transactions

845:
846:
847: SELECT transaction_date
848: INTO p_rts_txn_date
849: FROM rcv_transactions
850: WHERE transaction_id = p_rts_txn_id;
851:
852: --Bugfix:5395955
853: IF (p_po_dist_id IS NOT NULL) THEN

Line 990: --in rcv_transactions, hence need to join using po_header_id...

986: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;
987:
988: --Bug fix:1858452
989: --Note: When matched to a PO , po_distribution_id is not populated
990: --in rcv_transactions, hence need to join using po_header_id...
991:
992: /* For bug 2902340
993: Commented the following and added the same before calling all invoice
994: creation procedures.

Line 1001: rcv_transactions rct,

997: SELECT 'Y'
998: INTO l_invoice_exists
999: FROM ap_invoice_distributions aid,
1000: rcv_shipment_headers rsh,
1001: rcv_transactions rct,
1002: po_distributions pod
1003: WHERE aid.po_distribution_id = pod.po_distribution_id
1004: AND pod.line_location_id = rct.po_line_location_id
1005: AND rsh.shipment_header_id = rct.shipment_header_id