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

Line 80: FROM csi_item_instances cii,

76: SELECT cii.serial_number serial_number,
77: ct.transaction_quantity transaction_quantity,
78: ct.transaction_id transaction_id,
79: 'TO_PROJECT' issue_type
80: FROM csi_item_instances cii,
81: csi_item_instances_h ciih,
82: csi_transactions ct,
83: mtl_material_transactions mmt
84: WHERE cii.instance_id = ciih.instance_id

Line 81: csi_item_instances_h ciih,

77: ct.transaction_quantity transaction_quantity,
78: ct.transaction_id transaction_id,
79: 'TO_PROJECT' issue_type
80: FROM csi_item_instances cii,
81: csi_item_instances_h ciih,
82: csi_transactions ct,
83: mtl_material_transactions mmt
84: WHERE cii.instance_id = ciih.instance_id
85: AND ciih.transaction_id = ct.transaction_id

Line 98: FROM csi_item_instances cii,

94: SELECT cii.serial_number serial_number,
95: ct.transaction_quantity transaction_quantity,
96: ct.transaction_id transaction_id,
97: 'FROM_PROJECT' issue_type
98: FROM csi_item_instances cii,
99: csi_item_instances_h ciih,
100: csi_transactions ct,
101: mtl_material_transactions mmt
102: WHERE cii.instance_id = ciih.instance_id

Line 99: csi_item_instances_h ciih,

95: ct.transaction_quantity transaction_quantity,
96: ct.transaction_id transaction_id,
97: 'FROM_PROJECT' issue_type
98: FROM csi_item_instances cii,
99: csi_item_instances_h ciih,
100: csi_transactions ct,
101: mtl_material_transactions mmt
102: WHERE cii.instance_id = ciih.instance_id
103: AND ciih.transaction_id = ct.transaction_id

Line 413: FROM csi_item_instances cii,

409: cii.inv_master_organization_id,
410: ct.transaction_id,
411: ct.object_version_number,
412: ct.transaction_date
413: FROM csi_item_instances cii,
414: csi_item_instances_h ciih,
415: csi_transactions ct
416: WHERE ct.transaction_id = c_transaction_id
417: AND ct.transaction_id = ciih.transaction_id

Line 414: csi_item_instances_h ciih,

410: ct.transaction_id,
411: ct.object_version_number,
412: ct.transaction_date
413: FROM csi_item_instances cii,
414: csi_item_instances_h ciih,
415: csi_transactions ct
416: WHERE ct.transaction_id = c_transaction_id
417: AND ct.transaction_id = ciih.transaction_id
418: AND cii.instance_id = ciih.instance_id

Line 426: FROM csi_item_instances_h ciih

422:
423: CURSOR get_first_proj_cur (c_instance_id IN NUMBER, c_transaction_id IN NUMBER) IS
424: SELECT old_pa_project_id,
425: old_pa_project_task_id
426: FROM csi_item_instances_h ciih
427: WHERE ciih.instance_id = c_instance_id
428: ---We are looking for the immediate PROJ/TAsk info of the Receipt from Field Location transaction
429: AND ciih.transaction_id < c_transaction_id
430: AND old_location_type_code = 'PROJECT'