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.FV_DUE_DATE_CALCULATION dependencies on RCV_TRANSACTIONS

Line 78: rcv_transactions rcv,

74: rcv.po_header_id,
75: rcv.shipment_header_id
76: --pol.quantity_billed
77: FROM ap_invoice_distributions aid,
78: rcv_transactions rcv,
79: po_line_locations pol,
80: po_distributions po
81: WHERE aid.invoice_id = p_invoice_id
82: AND aid.match_status_flag = 'A'

Line 95: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;

91: rcv.transaction_date,
92: rcv.po_line_location_id;
93:
94: --LGOEL: Declaration of shipment_header_id
95: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
96:
97: v_po_header_id rcv_transactions.po_header_id%TYPE;
98:
99: v_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

Line 97: v_po_header_id rcv_transactions.po_header_id%TYPE;

93:
94: --LGOEL: Declaration of shipment_header_id
95: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
96:
97: v_po_header_id rcv_transactions.po_header_id%TYPE;
98:
99: v_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
100:
101: --LGOEL: Declare cursor to fetch acceptance date for receipt matched invoices

Line 99: v_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

95: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
96:
97: v_po_header_id rcv_transactions.po_header_id%TYPE;
98:
99: v_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
100:
101: --LGOEL: Declare cursor to fetch acceptance date for receipt matched invoices
102: --This was done to fix bug 1406383 as there can be multiple occurence of
103: --acceptance transaction type for same receipt

Line 108: FROM rcv_transactions

104: /* -- Commented out for bug 5454497
105: CURSOR c3_receipt_accept(p_po_header_id NUMBER) IS
106:
107: SELECT DISTINCT transaction_id,transaction_date
108: FROM rcv_transactions
109: WHERE
110: --shipment_header_id=v_shipment_header_id
111: po_header_id=p_po_header_id
112: AND transaction_type='ACCEPT'

Line 179: FROM rcv_transactions

175: IS
176: CURSOR c2_parent_receive (p_po_header_id NUMBER)
177: IS
178: SELECT DISTINCT transaction_id, transaction_date
179: FROM rcv_transactions
180: WHERE
181: --shipment_header_id=p_shipment_header_id
182: po_header_id=p_po_header_id
183: AND transaction_type='RECEIVE'

Line 197: v_transaction_type rcv_transactions.transaction_type%TYPE;

193: v_terms_id ap_invoices.terms_id%TYPE;
194: v_terms_date ap_invoices.terms_date%TYPE;
195: v_terms_type fv_terms_types.terms_type%TYPE;
196: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
197: v_transaction_type rcv_transactions.transaction_type%TYPE;
198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
199: v_transaction_date rcv_transactions.transaction_date%TYPE;
200: v_transaction_id rcv_transactions.transaction_id%TYPE;
201: v_quantity rcv_transactions.quantity%TYPE;

Line 198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;

194: v_terms_date ap_invoices.terms_date%TYPE;
195: v_terms_type fv_terms_types.terms_type%TYPE;
196: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
197: v_transaction_type rcv_transactions.transaction_type%TYPE;
198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
199: v_transaction_date rcv_transactions.transaction_date%TYPE;
200: v_transaction_id rcv_transactions.transaction_id%TYPE;
201: v_quantity rcv_transactions.quantity%TYPE;
202: v_quantity_billed po_line_locations.quantity_billed%TYPE;

Line 199: v_transaction_date rcv_transactions.transaction_date%TYPE;

195: v_terms_type fv_terms_types.terms_type%TYPE;
196: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
197: v_transaction_type rcv_transactions.transaction_type%TYPE;
198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
199: v_transaction_date rcv_transactions.transaction_date%TYPE;
200: v_transaction_id rcv_transactions.transaction_id%TYPE;
201: v_quantity rcv_transactions.quantity%TYPE;
202: v_quantity_billed po_line_locations.quantity_billed%TYPE;
203: v_due_days ap_terms_lines.due_days%TYPE;

Line 200: v_transaction_id rcv_transactions.transaction_id%TYPE;

196: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
197: v_transaction_type rcv_transactions.transaction_type%TYPE;
198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
199: v_transaction_date rcv_transactions.transaction_date%TYPE;
200: v_transaction_id rcv_transactions.transaction_id%TYPE;
201: v_quantity rcv_transactions.quantity%TYPE;
202: v_quantity_billed po_line_locations.quantity_billed%TYPE;
203: v_due_days ap_terms_lines.due_days%TYPE;
204: --v_receipt_acceptance_days

Line 201: v_quantity rcv_transactions.quantity%TYPE;

197: v_transaction_type rcv_transactions.transaction_type%TYPE;
198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
199: v_transaction_date rcv_transactions.transaction_date%TYPE;
200: v_transaction_id rcv_transactions.transaction_id%TYPE;
201: v_quantity rcv_transactions.quantity%TYPE;
202: v_quantity_billed po_line_locations.quantity_billed%TYPE;
203: v_due_days ap_terms_lines.due_days%TYPE;
204: --v_receipt_acceptance_days
205: --financials_system_parameters.receipt_acceptance_days%TYPE;

Line 222: v_parent_transaction_id rcv_transactions.transaction_id%TYPE;

218: v_new_discount_date DATE;
219: v_rec_transaction_date DATE;
220: v_invoice_date DATE;
221: v_invoice_return_days NUMBER;
222: v_parent_transaction_id rcv_transactions.transaction_id%TYPE;
223: v_diff_days NUMBER;
224: v_con_acc_days NUMBER;
225: v_discount_days NUMBER;
226: v_dummy VARCHAR2(2);

Line 228: v_last_transaction_type rcv_transactions.transaction_type%TYPE;

224: v_con_acc_days NUMBER;
225: v_discount_days NUMBER;
226: v_dummy VARCHAR2(2);
227: v_tot_inv_retn NUMBER;
228: v_last_transaction_type rcv_transactions.transaction_type%TYPE;
229: v_type rcv_transactions.transaction_type%TYPE;
230: v_transaction_id_org rcv_transactions.transaction_id%TYPE;
231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;
232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;

Line 229: v_type rcv_transactions.transaction_type%TYPE;

225: v_discount_days NUMBER;
226: v_dummy VARCHAR2(2);
227: v_tot_inv_retn NUMBER;
228: v_last_transaction_type rcv_transactions.transaction_type%TYPE;
229: v_type rcv_transactions.transaction_type%TYPE;
230: v_transaction_id_org rcv_transactions.transaction_id%TYPE;
231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;
232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;
233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;

Line 230: v_transaction_id_org rcv_transactions.transaction_id%TYPE;

226: v_dummy VARCHAR2(2);
227: v_tot_inv_retn NUMBER;
228: v_last_transaction_type rcv_transactions.transaction_type%TYPE;
229: v_type rcv_transactions.transaction_type%TYPE;
230: v_transaction_id_org rcv_transactions.transaction_id%TYPE;
231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;
232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;
233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;
234: v_transaction_date_org DATE;

Line 231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;

227: v_tot_inv_retn NUMBER;
228: v_last_transaction_type rcv_transactions.transaction_type%TYPE;
229: v_type rcv_transactions.transaction_type%TYPE;
230: v_transaction_id_org rcv_transactions.transaction_id%TYPE;
231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;
232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;
233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;
234: v_transaction_date_org DATE;
235: v_final_shipment_header_id rcv_transactions.shipment_header_id%TYPE;

Line 232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;

228: v_last_transaction_type rcv_transactions.transaction_type%TYPE;
229: v_type rcv_transactions.transaction_type%TYPE;
230: v_transaction_id_org rcv_transactions.transaction_id%TYPE;
231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;
232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;
233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;
234: v_transaction_date_org DATE;
235: v_final_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
236: v_final_transaction_date rcv_transactions.transaction_date%TYPE;

Line 233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;

229: v_type rcv_transactions.transaction_type%TYPE;
230: v_transaction_id_org rcv_transactions.transaction_id%TYPE;
231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;
232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;
233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;
234: v_transaction_date_org DATE;
235: v_final_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
236: v_final_transaction_date rcv_transactions.transaction_date%TYPE;
237: v_hol_day VARCHAR2(10);

Line 235: v_final_shipment_header_id rcv_transactions.shipment_header_id%TYPE;

231: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;
232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;
233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;
234: v_transaction_date_org DATE;
235: v_final_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
236: v_final_transaction_date rcv_transactions.transaction_date%TYPE;
237: v_hol_day VARCHAR2(10);
238: v_user NUMBER;
239: v_rec_trxn_flag VARCHAR2(1);

Line 236: v_final_transaction_date rcv_transactions.transaction_date%TYPE;

232: v_transaction_type_org rcv_transactions.transaction_type%TYPE;
233: v_rec_txn_type rcv_transactions.transaction_type%TYPE;
234: v_transaction_date_org DATE;
235: v_final_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
236: v_final_transaction_date rcv_transactions.transaction_date%TYPE;
237: v_hol_day VARCHAR2(10);
238: v_user NUMBER;
239: v_rec_trxn_flag VARCHAR2(1);
240: v_exists VARCHAR2(1);

Line 468: FROM fv_rcv_transactions

464: /* Checking for new transaction_date from closed period */
465: BEGIN
466: SELECT actual_transaction_date
467: INTO v_transaction_date
468: FROM fv_rcv_transactions
469: WHERE transaction_id = v_transaction_id_org;
470: EXCEPTION
471: WHEN NO_DATA_FOUND THEN
472: v_transaction_date := v_transaction_date_org;

Line 491: FROM rcv_transactions

487: -- flipped to add instead of subtracting
488: SELECT NVL(SUM(DECODE(transaction_type ,
489: 'CORRECT',quantity, quantity * -1)),0)
490: INTO v_correct_quantity
491: FROM rcv_transactions
492: WHERE transaction_type IN ('CORRECT','RETURN TO VENDOR')
493: AND parent_transaction_id = v_transaction_id;
494:
495: /* summing total quandity */

Line 572: FROM fv_rcv_transactions

568: /* Read new transaction date,if any defined on */
569: BEGIN
570: SELECT actual_transaction_date
571: INTO v_rec_transaction_date
572: FROM fv_rcv_transactions
573: WHERE transaction_id = v_parent_transaction_id;
574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN
576: NULL;

Line 604: FROM rcv_transactions acc, rcv_transactions rec

600: v_rcv_trans_count := 0;
601:
602: SELECT count(*)
603: INTO v_rcv_trans_count
604: FROM rcv_transactions acc, rcv_transactions rec
605: WHERE acc.po_header_id = v_po_header_id
606: AND acc.transaction_type='ACCEPT'
607: AND acc.parent_transaction_id = rec.transaction_id
608: AND rec.transaction_type <> 'RECEIVE';

Line 613: FROM rcv_transactions

609:
610: IF v_rcv_trans_count > 0 THEN
611:
612: l_statement := ' SELECT DISTINCT transaction_id,transaction_date
613: FROM rcv_transactions
614: WHERE po_header_id = :v_po_header_id
615: AND transaction_type = ''ACCEPT''
616: START WITH transaction_type =''RECEIVE''
617: CONNECT BY parent_transaction_id = PRIOR transaction_id

Line 622: FROM rcv_transactions rec, rcv_transactions acc

618: ORDER BY transaction_date DESC ';
619: ELSE
620:
621: l_statement := ' SELECT DISTINCT acc.transaction_id,acc.transaction_date
622: FROM rcv_transactions rec, rcv_transactions acc
623: WHERE rec.po_header_id = :v_po_header_id
624: AND rec.transaction_type = ''RECEIVE''
625: AND rec.transaction_id = acc.parent_transaction_id
626: AND acc.transaction_type = ''ACCEPT''

Line 650: FROM fv_rcv_transactions

646: /* Read new transaction date,if any defined on */
647: BEGIN
648: SELECT actual_transaction_date
649: INTO v_transaction_date
650: FROM fv_rcv_transactions
651: WHERE transaction_id = v_transaction_id;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: NULL;