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.RCV_ACCRUALUTILITIES_GRP dependencies on FND_DATE

Line 1190: and fnd_date.date_to_canonical(rt.transaction_date)

1186: from mtl_material_transactions mmt,
1187: mtl_transaction_accounts mta,
1188: rcv_transactions rt
1189: where rt.po_distribution_id = p_po_distribution_id
1190: and fnd_date.date_to_canonical(rt.transaction_date)
1191: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1192: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1193: and mmt.rcv_transaction_id = rt.transaction_id
1194: and mta.transaction_id = mmt.transaction_id

Line 1191: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))

1187: mtl_transaction_accounts mta,
1188: rcv_transactions rt
1189: where rt.po_distribution_id = p_po_distribution_id
1190: and fnd_date.date_to_canonical(rt.transaction_date)
1191: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1192: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1193: and mmt.rcv_transaction_id = rt.transaction_id
1194: and mta.transaction_id = mmt.transaction_id
1195: and mta.accounting_line_type = 15

Line 1192: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))

1188: rcv_transactions rt
1189: where rt.po_distribution_id = p_po_distribution_id
1190: and fnd_date.date_to_canonical(rt.transaction_date)
1191: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1192: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1193: and mmt.rcv_transaction_id = rt.transaction_id
1194: and mta.transaction_id = mmt.transaction_id
1195: and mta.accounting_line_type = 15
1196: and NVL(mta.gl_batch_id, 0) <> -1;

Line 1205: and fnd_date.date_to_canonical(rt.transaction_date)

1201: into l_encReversalAmt
1202: from rcv_receiving_sub_ledger rrs,
1203: rcv_transactions rt
1204: where rt.po_distribution_id = p_po_distribution_id
1205: and fnd_date.date_to_canonical(rt.transaction_date)
1206: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1207: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1208: and rrs.rcv_transaction_id = rt.transaction_id
1209: and rrs.actual_flag = 'E';

Line 1206: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))

1202: from rcv_receiving_sub_ledger rrs,
1203: rcv_transactions rt
1204: where rt.po_distribution_id = p_po_distribution_id
1205: and fnd_date.date_to_canonical(rt.transaction_date)
1206: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1207: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1208: and rrs.rcv_transaction_id = rt.transaction_id
1209: and rrs.actual_flag = 'E';
1210: else

Line 1207: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))

1203: rcv_transactions rt
1204: where rt.po_distribution_id = p_po_distribution_id
1205: and fnd_date.date_to_canonical(rt.transaction_date)
1206: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1207: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1208: and rrs.rcv_transaction_id = rt.transaction_id
1209: and rrs.actual_flag = 'E';
1210: else
1211: l_stmt_num := 60;