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 96: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;

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

Line 98: v_po_header_id rcv_transactions.po_header_id%TYPE;

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

Line 100: v_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

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

Line 109: FROM rcv_transactions

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

Line 180: FROM rcv_transactions

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

Line 198: v_transaction_type rcv_transactions.transaction_type%TYPE;

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

Line 199: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;

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

Line 200: v_transaction_date rcv_transactions.transaction_date%TYPE;

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

Line 201: v_transaction_id rcv_transactions.transaction_id%TYPE;

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

Line 202: v_quantity rcv_transactions.quantity%TYPE;

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

Line 223: v_parent_transaction_id rcv_transactions.transaction_id%TYPE;

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

Line 229: v_last_transaction_type rcv_transactions.transaction_type%TYPE;

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

Line 230: v_type rcv_transactions.transaction_type%TYPE;

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

Line 231: v_transaction_id_org rcv_transactions.transaction_id%TYPE;

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

Line 232: v_parent_transaction_id_org rcv_transactions.transaction_id%TYPE;

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

Line 233: v_transaction_type_org rcv_transactions.transaction_type%TYPE;

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

Line 234: v_rec_txn_type rcv_transactions.transaction_type%TYPE;

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

Line 236: v_final_shipment_header_id rcv_transactions.shipment_header_id%TYPE;

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

Line 237: v_final_transaction_date rcv_transactions.transaction_date%TYPE;

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

Line 475: FROM fv_rcv_transactions

471: /* Checking for new transaction_date from closed period */
472: BEGIN
473: SELECT actual_transaction_date
474: INTO v_transaction_date
475: FROM fv_rcv_transactions
476: WHERE transaction_id = v_transaction_id_org;
477: EXCEPTION
478: WHEN NO_DATA_FOUND THEN
479: v_transaction_date := v_transaction_date_org;

Line 498: FROM rcv_transactions

494: -- flipped to add instead of subtracting
495: SELECT NVL(SUM(DECODE(transaction_type ,
496: 'CORRECT',quantity, quantity * -1)),0)
497: INTO v_correct_quantity
498: FROM rcv_transactions
499: WHERE transaction_type IN ('CORRECT','RETURN TO VENDOR')
500: AND parent_transaction_id = v_transaction_id;
501:
502: /* summing total quandity */

Line 579: FROM fv_rcv_transactions

575: /* Read new transaction date,if any defined on */
576: BEGIN
577: SELECT actual_transaction_date
578: INTO v_rec_transaction_date
579: FROM fv_rcv_transactions
580: WHERE transaction_id = v_parent_transaction_id;
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN
583: NULL;

Line 611: FROM rcv_transactions acc, rcv_transactions rec

607: v_rcv_trans_count := 0;
608:
609: SELECT count(*)
610: INTO v_rcv_trans_count
611: FROM rcv_transactions acc, rcv_transactions rec
612: WHERE acc.po_header_id = v_po_header_id
613: AND acc.transaction_type='ACCEPT'
614: AND acc.parent_transaction_id = rec.transaction_id
615: AND rec.transaction_type <> 'RECEIVE';

Line 620: FROM rcv_transactions

616:
617: IF v_rcv_trans_count > 0 THEN
618:
619: l_statement := ' SELECT DISTINCT transaction_id,transaction_date
620: FROM rcv_transactions
621: WHERE po_header_id = :v_po_header_id
622: AND transaction_type = ''ACCEPT''
623: START WITH transaction_type =''RECEIVE''
624: CONNECT BY parent_transaction_id = PRIOR transaction_id

Line 629: FROM rcv_transactions rec, rcv_transactions acc

625: ORDER BY transaction_date DESC ';
626: ELSE
627:
628: l_statement := ' SELECT DISTINCT acc.transaction_id,acc.transaction_date
629: FROM rcv_transactions rec, rcv_transactions acc
630: WHERE rec.po_header_id = :v_po_header_id
631: AND rec.transaction_type = ''RECEIVE''
632: AND rec.transaction_id = acc.parent_transaction_id
633: AND acc.transaction_type = ''ACCEPT''

Line 657: FROM fv_rcv_transactions

653: /* Read new transaction date,if any defined on */
654: BEGIN
655: SELECT actual_transaction_date
656: INTO v_transaction_date
657: FROM fv_rcv_transactions
658: WHERE transaction_id = v_transaction_id;
659: EXCEPTION
660: WHEN NO_DATA_FOUND THEN
661: NULL;