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.CSI_ITEM_INSTANCE_PVT dependencies on CSI_I_ORG_ASSIGNMENTS_H

Line 3281: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||

3277: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||
3278: ' WHERE a.attribute_value_id = b.attribute_value_id AND a.transaction_id = :p_transaction_id '||
3279: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||
3280: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3281: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3282: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3283: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||
3284: ' WHERE a.pricing_attribute_id = b.pricing_attribute_id and b.transaction_id = :p_transaction_id '||
3285: ' UNION SELECT a.instance_id FROM csi_i_version_labels a, csi_i_version_labels_h b '||

Line 11030: FROM CSI_I_ORG_ASSIGNMENTS_H CIOAH, CSI_I_ORG_ASSIGNMENTS CIOA

11026: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11027: UNION ALL
11028:
11029: SELECT CIOAH.TRANSACTION_ID TRANSACTION_ID, CIOA.INSTANCE_ID INSTANCE_ID
11030: FROM CSI_I_ORG_ASSIGNMENTS_H CIOAH, CSI_I_ORG_ASSIGNMENTS CIOA
11031: WHERE CIOAH.INSTANCE_OU_ID = CIOA.INSTANCE_OU_ID
11032: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11033: UNION ALL
11034: