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 3255: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||

3251: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||
3252: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3253: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3254: ' and transaction_id = :p_transaction_id UNION '||
3255: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3256: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3257: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
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 '||

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

3252: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3253: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3254: ' and transaction_id = :p_transaction_id UNION '||
3255: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3256: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3257: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
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 '||

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

3393:
3394: IF l_party_rec_exists then
3395:
3396: IF l_instance_rec_exists THEN
3397: l_from_clause := l_from_clause||' , csi_ip_accounts c ';
3398: l_join_condition := l_join_condition||' AND b.instance_party_id = c.instance_party_id ';
3399:
3400: ELSE
3401: l_from_clause := l_from_clause||' , csi_ip_accounts c ';

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

3397: l_from_clause := l_from_clause||' , csi_ip_accounts c ';
3398: l_join_condition := l_join_condition||' AND b.instance_party_id = c.instance_party_id ';
3399:
3400: ELSE
3401: l_from_clause := l_from_clause||' , csi_ip_accounts c ';
3402: l_join_condition := ' b.instance_party_id = c.instance_party_id ';
3403:
3404: END IF;
3405:

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

3405:
3406: ELSE
3407:
3408: IF l_instance_rec_exists THEN
3409: l_from_clause := l_from_clause||' , csi_i_parties b , csi_ip_accounts c ';
3410: l_join_condition := ' a.instance_id = b.instance_id AND b.instance_party_id = c.instance_party_id ';
3411: ELSE
3412: l_from_clause := ' csi_i_parties b , csi_ip_accounts c ';
3413: l_join_condition := ' b.instance_party_id = c.instance_party_id ';

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

3408: IF l_instance_rec_exists THEN
3409: l_from_clause := l_from_clause||' , csi_i_parties b , csi_ip_accounts c ';
3410: l_join_condition := ' a.instance_id = b.instance_id AND b.instance_party_id = c.instance_party_id ';
3411: ELSE
3412: l_from_clause := ' csi_i_parties b , csi_ip_accounts c ';
3413: l_join_condition := ' b.instance_party_id = c.instance_party_id ';
3414: l_select_columns := ' b.instance_id ';
3415: END IF;
3416:

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

10768: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10769: UNION ALL
10770:
10771: SELECT CIAH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
10772: FROM CSI_IP_ACCOUNTS_H CIAH, CSI_IP_ACCOUNTS CIA, CSI_I_PARTIES CIP
10773: WHERE CIAH.IP_ACCOUNT_ID = CIA.IP_ACCOUNT_ID
10774: AND CIA.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
10775: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10776: UNION ALL