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_IP_ACCOUNTS

Line 3274: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||

3270: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||
3271: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3272: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3273: ' and transaction_id = :p_transaction_id UNION '||
3274: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3275: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3276: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
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 '||

Line 3275: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||

3271: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3272: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3273: ' and transaction_id = :p_transaction_id UNION '||
3274: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3275: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3276: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
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 '||

Line 3416: l_from_clause := l_from_clause||' , csi_ip_accounts c ';

3412:
3413: IF l_party_rec_exists then
3414:
3415: IF l_instance_rec_exists THEN
3416: l_from_clause := l_from_clause||' , csi_ip_accounts c ';
3417: l_join_condition := l_join_condition||' AND b.instance_party_id = c.instance_party_id ';
3418:
3419: ELSE
3420: l_from_clause := l_from_clause||' , csi_ip_accounts c ';

Line 3420: l_from_clause := l_from_clause||' , csi_ip_accounts c ';

3416: l_from_clause := l_from_clause||' , csi_ip_accounts c ';
3417: l_join_condition := l_join_condition||' AND b.instance_party_id = c.instance_party_id ';
3418:
3419: ELSE
3420: l_from_clause := l_from_clause||' , csi_ip_accounts c ';
3421: l_join_condition := ' b.instance_party_id = c.instance_party_id ';
3422:
3423: END IF;
3424:

Line 3428: l_from_clause := l_from_clause||' , csi_i_parties b , csi_ip_accounts c ';

3424:
3425: ELSE
3426:
3427: IF l_instance_rec_exists THEN
3428: l_from_clause := l_from_clause||' , csi_i_parties b , csi_ip_accounts c ';
3429: l_join_condition := ' a.instance_id = b.instance_id AND b.instance_party_id = c.instance_party_id ';
3430: ELSE
3431: l_from_clause := ' csi_i_parties b , csi_ip_accounts c ';
3432: l_join_condition := ' b.instance_party_id = c.instance_party_id ';

Line 3431: l_from_clause := ' csi_i_parties b , csi_ip_accounts c ';

3427: IF l_instance_rec_exists THEN
3428: l_from_clause := l_from_clause||' , csi_i_parties b , csi_ip_accounts c ';
3429: l_join_condition := ' a.instance_id = b.instance_id AND b.instance_party_id = c.instance_party_id ';
3430: ELSE
3431: l_from_clause := ' csi_i_parties b , csi_ip_accounts c ';
3432: l_join_condition := ' b.instance_party_id = c.instance_party_id ';
3433: l_select_columns := ' b.instance_id ';
3434: END IF;
3435:

Line 11023: FROM CSI_IP_ACCOUNTS_H CIAH, CSI_IP_ACCOUNTS CIA, CSI_I_PARTIES CIP

11019: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11020: UNION ALL
11021:
11022: SELECT CIAH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
11023: FROM CSI_IP_ACCOUNTS_H CIAH, CSI_IP_ACCOUNTS CIA, CSI_I_PARTIES CIP
11024: WHERE CIAH.IP_ACCOUNT_ID = CIA.IP_ACCOUNT_ID
11025: AND CIA.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
11026: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11027: UNION ALL