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_TXN_PKG dependencies on CSI_TRANSACTIONS

Line 77: FROM csi_item_instances_h cih, csi_transactions ct

73:
74: BEGIN
75: SELECT old_inst_usage_code
76: INTO l_h_instance_usage_code
77: FROM csi_item_instances_h cih, csi_transactions ct
78: WHERE cih.instance_id = l_u_instance_rec.instance_id
79: AND cih.transaction_id = ct.transaction_id
80: AND ct.TRANSACTION_TYPE_ID = 104
81: AND old_inst_usage_code IS NOT NULL

Line 94: FROM csi_item_instances_h cih, csi_transactions ct

90:
91: BEGIN
92: SELECT old_instance_status_id
93: INTO l_h_Instance_status_id
94: FROM csi_item_instances_h cih, csi_transactions ct
95: WHERE cih.instance_id = l_u_instance_rec.instance_id
96: AND cih.transaction_id = ct.transaction_id
97: AND ct.TRANSACTION_TYPE_ID = 104
98: AND old_instance_status_id IS NOT NULL

Line 360: csi_transactions ct

356: END IF;
357: /* SELECT citdv.instance_id,citdv.*
358: FROM csi_i_assets_h ciah,
359: csi_item_instances_h ciih,
360: csi_transactions ct
361: WHERE ciah.transaction_id = ciih.transaction_id
362: AND citdv.transaction_type_id = 104
363: AND ciah.instance_asset_id = 75478
364: