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_PARTIES

Line 3270: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||

3266: --End Addition
3267:
3268: l_union_stmt VARCHAR2(2000) := ' select instance_id from csi_item_instances_h '||
3269: ' where transaction_id = :p_transaction_id UNION select a.instance_id '||
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, '||

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 3393: l_from_clause := l_from_clause||' , csi_i_parties b ';

3389: OR (p_party_query_rec.relationship_type_code IS NULL ) THEN
3390:
3391: l_party_rec_exists := TRUE;
3392: IF l_instance_rec_exists THEN
3393: l_from_clause := l_from_clause||' , csi_i_parties b ';
3394: l_join_condition := ' a.instance_id = b.instance_id ';
3395: ELSE
3396: l_from_clause := ' csi_i_parties b ';
3397: l_select_columns := ' b.instance_id ';

Line 3396: l_from_clause := ' csi_i_parties b ';

3392: IF l_instance_rec_exists THEN
3393: l_from_clause := l_from_clause||' , csi_i_parties b ';
3394: l_join_condition := ' a.instance_id = b.instance_id ';
3395: ELSE
3396: l_from_clause := ' csi_i_parties b ';
3397: l_select_columns := ' b.instance_id ';
3398: END IF;
3399:
3400: END IF;

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 10232: from CSI_I_PARTIES

10228: l_party_id := NULL;
10229: Begin
10230: select party_id
10231: into l_party_id
10232: from CSI_I_PARTIES
10233: where instance_id = l_rel_tbl(j).subject_id
10234: and relationship_type_code = 'OWNER';
10235: Exception
10236: when no_data_found then

Line 11011: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP

11007: AND object_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11008: UNION ALL
11009:
11010: SELECT CIPH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
11011: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP
11012: WHERE CIPH.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
11013: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11014: UNION ALL
11015:

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

Line 11797: FROM csi_i_parties

11793: NULL CALL_CONTRACTS,
11794: NULL INTERFACE_ID,
11795: NULL CONTACT_PARENT_TBL_INDEX,
11796: NULL CASCADE_OWNERSHIP_FLAG -- Added for bug 2972082
11797: FROM csi_i_parties
11798: WHERE instance_id = p_instance_id
11799: AND relationship_type_code = 'OWNER';
11800:
11801:

Line 29625: FROM csi_i_parties cip

29621: --
29622: BEGIN
29623: SELECT cip.party_id
29624: INTO l_party_id
29625: FROM csi_i_parties cip
29626: WHERE cip.instance_id = x_new_instance_tbl(1).instance_id
29627: AND cip.relationship_type_code = 'OWNER';
29628: EXCEPTION
29629: WHEN OTHERS THEN

Line 34432: FROM csi_i_parties cip

34428:
34429: BEGIN
34430: SELECT cip.party_id
34431: INTO l_party_id
34432: FROM csi_i_parties cip
34433: WHERE cip.instance_id = x_new_instance_tbl(1).instance_id
34434: AND cip.relationship_type_code = 'OWNER';
34435: EXCEPTION
34436: WHEN OTHERS THEN