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 73: FROM csi_item_instances cii,

69: SELECT cii.serial_number serial_number,
70: ct.transaction_quantity transaction_quantity,
71: ct.transaction_id transaction_id,
72: 'TO_PROJECT' issue_type
73: FROM csi_item_instances cii,
74: csi_item_instances_h ciih,
75: csi_transactions ct
76: WHERE cii.instance_id = ciih.instance_id
77: AND ciih.transaction_id = ct.transaction_id

Line 74: csi_item_instances_h ciih,

70: ct.transaction_quantity transaction_quantity,
71: ct.transaction_id transaction_id,
72: 'TO_PROJECT' issue_type
73: FROM csi_item_instances cii,
74: csi_item_instances_h ciih,
75: csi_transactions ct
76: WHERE cii.instance_id = ciih.instance_id
77: AND ciih.transaction_id = ct.transaction_id
78: AND ct.inv_material_transaction_id = c_txn_id

Line 88: FROM csi_item_instances cii,

84: SELECT cii.serial_number serial_number,
85: ct.transaction_quantity transaction_quantity,
86: ct.transaction_id transaction_id,
87: 'FROM_PROJECT' issue_type
88: FROM csi_item_instances cii,
89: csi_item_instances_h ciih,
90: csi_transactions ct
91: WHERE cii.instance_id = ciih.instance_id
92: AND ciih.transaction_id = ct.transaction_id

Line 89: csi_item_instances_h ciih,

85: ct.transaction_quantity transaction_quantity,
86: ct.transaction_id transaction_id,
87: 'FROM_PROJECT' issue_type
88: FROM csi_item_instances cii,
89: csi_item_instances_h ciih,
90: csi_transactions ct
91: WHERE cii.instance_id = ciih.instance_id
92: AND ciih.transaction_id = ct.transaction_id
93: AND ct.inv_material_transaction_id = c_txn_id

Line 400: FROM csi_item_instances cii,

396: cii.inv_master_organization_id,
397: ct.transaction_id,
398: ct.object_version_number,
399: ct.transaction_date
400: FROM csi_item_instances cii,
401: csi_item_instances_h ciih,
402: csi_transactions ct
403: WHERE ct.transaction_id = c_transaction_id
404: AND ct.transaction_id = ciih.transaction_id

Line 401: csi_item_instances_h ciih,

397: ct.transaction_id,
398: ct.object_version_number,
399: ct.transaction_date
400: FROM csi_item_instances cii,
401: csi_item_instances_h ciih,
402: csi_transactions ct
403: WHERE ct.transaction_id = c_transaction_id
404: AND ct.transaction_id = ciih.transaction_id
405: AND cii.instance_id = ciih.instance_id

Line 413: FROM csi_item_instances_h ciih

409:
410: CURSOR get_first_proj_cur (c_instance_id IN NUMBER, c_transaction_id IN NUMBER) IS
411: SELECT old_pa_project_id,
412: old_pa_project_task_id
413: FROM csi_item_instances_h ciih
414: WHERE ciih.instance_id = c_instance_id
415: ---We are looking for the immediate PROJ/TAsk info of the Receipt from Field Location transaction
416: AND ciih.transaction_id < c_transaction_id
417: AND old_location_type_code = 'PROJECT'