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 286: Retreive all required information from rcv_transactions */

282: curr_calling_sequence := p_calling_sequence ||' <- Create_DM';
283: l_invoice_exists := 'N';
284:
285: /* STEP 1:
286: Retreive all required information from rcv_transactions */
287:
288: debug_info := 'Retreive receipt information';
289:
290: --Bug fix:1413339

Line 820: GET_RECEIPT_INFO : Gets relevant information from rcv_transactions and

816:
817: /* Private Procedure/functions */
818:
819: /*-------------------------------------------------------------------------
820: GET_RECEIPT_INFO : Gets relevant information from rcv_transactions and
821: po_shipments
822: --------------------------------------------------------------------------*/
823: Procedure Get_receipt_info(
824: p_rcv_txn_id IN NUMBER,

Line 896: rcv_transactions rtxn,

892: p_match_option, --bug2902340
893: p_org_id,
894: p_po_uom
895: FROM
896: rcv_transactions rtxn,
897: rcv_shipment_headers rsh,
898: rcv_shipment_lines rsl,
899: po_headers ph,
900: po_line_locations pll,

Line 920: FROM rcv_transactions

916:
917:
918: SELECT transaction_date
919: INTO p_rts_txn_date
920: FROM rcv_transactions
921: WHERE transaction_id = p_rts_txn_id;
922:
923: --Bugfix:5395955
924: IF (p_po_dist_id IS NOT NULL) THEN

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

1058: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;
1059:
1060: --Bug fix:1858452
1061: --Note: When matched to a PO , po_distribution_id is not populated
1062: --in rcv_transactions, hence need to join using po_header_id...
1063:
1064: /* For bug 2902340
1065: Commented the following and added the same before calling all invoice
1066: creation procedures.

Line 1073: rcv_transactions rct,

1069: SELECT 'Y'
1070: INTO l_invoice_exists
1071: FROM ap_invoice_distributions aid,
1072: rcv_shipment_headers rsh,
1073: rcv_transactions rct,
1074: po_distributions pod
1075: WHERE aid.po_distribution_id = pod.po_distribution_id
1076: AND pod.line_location_id = rct.po_line_location_id
1077: AND rsh.shipment_header_id = rct.shipment_header_id