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.CSE_FA_STAGE_PKG dependencies on CSI_FA_TRANSACTIONS

Line 245: SELECT csi_fa_transactions_s.nextval

241: IF p_asset_dist_tbl.COUNT > 0 THEN
242: FOR dist_ind IN p_asset_dist_tbl.FIRST .. p_asset_dist_tbl.LAST
243: LOOP
244:
245: SELECT csi_fa_transactions_s.nextval
246: INTO l_interface_line_id
247: FROM sys.dual;
248:
249: csi_fa_transactions_pkg.INSERT_ROW (

Line 249: csi_fa_transactions_pkg.INSERT_ROW (

245: SELECT csi_fa_transactions_s.nextval
246: INTO l_interface_line_id
247: FROM sys.dual;
248:
249: csi_fa_transactions_pkg.INSERT_ROW (
250: X_ROWID => l_rowid,
251: X_INTERFACE_LINE_ID => l_interface_line_id,
252: X_INTERFACE_HEADER_ID => l_interface_header_id,
253: X_DISTRIBUTION_ID => p_asset_dist_tbl(dist_ind).distribution_id,

Line 348: csi_fa_transactions cft,

344: cft.transaction_date,
345: cft.transaction_cost,
346: cfh.feeder_system_name
347: FROM csi_fa_headers cfh,
348: csi_fa_transactions cft,
349: fa_additions fa
350: WHERE cfh.status_code = 'NEW'
351: AND cft.interface_header_id = cfh.interface_header_id
352: AND cft.status_code = 'NEW'