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_FAC_INSERVICE_PKG dependencies on CSI_ITEM_INSTANCES

Line 133: FROM csi_item_instances_h ciih,

129: cii.quantity,
130: cii.location_type_code,
131: cii.location_id,
132: cii.operational_status_code
133: FROM csi_item_instances_h ciih,
134: csi_item_instances cii
135: WHERE ciih.transaction_id = p_csi_txn_id
136: AND cii.instance_id = ciih.instance_id
137: AND (cii.operational_status_code = 'IN_SERVICE' OR ciih.new_operational_status_code = 'IN_SERVICE');

Line 134: csi_item_instances cii

130: cii.location_type_code,
131: cii.location_id,
132: cii.operational_status_code
133: FROM csi_item_instances_h ciih,
134: csi_item_instances cii
135: WHERE ciih.transaction_id = p_csi_txn_id
136: AND cii.instance_id = ciih.instance_id
137: AND (cii.operational_status_code = 'IN_SERVICE' OR ciih.new_operational_status_code = 'IN_SERVICE');
138:

Line 926: FROM csi_item_instances_h ciih,

922:
923: CURSOR insrv_inst_cur(p_csi_txn_id IN number) IS
924: SELECT cii.instance_id,
925: cii.serial_number
926: FROM csi_item_instances_h ciih,
927: csi_item_instances cii
928: WHERE ciih.transaction_id = p_csi_txn_id
929: AND cii.instance_id = ciih.instance_id
930: AND (ciih.new_operational_status_code = 'IN_SERVICE' OR cii.operational_status_code = 'IN_SERVICE');

Line 927: csi_item_instances cii

923: CURSOR insrv_inst_cur(p_csi_txn_id IN number) IS
924: SELECT cii.instance_id,
925: cii.serial_number
926: FROM csi_item_instances_h ciih,
927: csi_item_instances cii
928: WHERE ciih.transaction_id = p_csi_txn_id
929: AND cii.instance_id = ciih.instance_id
930: AND (ciih.new_operational_status_code = 'IN_SERVICE' OR cii.operational_status_code = 'IN_SERVICE');
931: