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

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

3258: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||
3259: ' WHERE a.attribute_value_id = b.attribute_value_id AND a.transaction_id = :p_transaction_id '||
3260: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||
3261: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3262: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3263: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3264: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||
3265: ' WHERE a.pricing_attribute_id = b.pricing_attribute_id and b.transaction_id = :p_transaction_id '||
3266: ' UNION SELECT a.instance_id FROM csi_i_version_labels a, csi_i_version_labels_h b '||

Line 10779: FROM CSI_I_ORG_ASSIGNMENTS_H CIOAH, CSI_I_ORG_ASSIGNMENTS CIOA

10775: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10776: UNION ALL
10777:
10778: SELECT CIOAH.TRANSACTION_ID TRANSACTION_ID, CIOA.INSTANCE_ID INSTANCE_ID
10779: FROM CSI_I_ORG_ASSIGNMENTS_H CIOAH, CSI_I_ORG_ASSIGNMENTS CIOA
10780: WHERE CIOAH.INSTANCE_OU_ID = CIOA.INSTANCE_OU_ID
10781: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10782: UNION ALL
10783: