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 3251: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||

3247: --End Addition
3248:
3249: l_union_stmt VARCHAR2(2000) := ' select instance_id from csi_item_instances_h '||
3250: ' where transaction_id = :p_transaction_id UNION select a.instance_id '||
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, '||

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

3370: OR (p_party_query_rec.relationship_type_code IS NULL ) THEN
3371:
3372: l_party_rec_exists := TRUE;
3373: IF l_instance_rec_exists THEN
3374: l_from_clause := l_from_clause||' , csi_i_parties b ';
3375: l_join_condition := ' a.instance_id = b.instance_id ';
3376: ELSE
3377: l_from_clause := ' csi_i_parties b ';
3378: l_select_columns := ' b.instance_id ';

Line 3377: l_from_clause := ' csi_i_parties b ';

3373: IF l_instance_rec_exists THEN
3374: l_from_clause := l_from_clause||' , csi_i_parties b ';
3375: l_join_condition := ' a.instance_id = b.instance_id ';
3376: ELSE
3377: l_from_clause := ' csi_i_parties b ';
3378: l_select_columns := ' b.instance_id ';
3379: END IF;
3380:
3381: END IF;

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

10006: l_party_id := NULL;
10007: Begin
10008: select party_id
10009: into l_party_id
10010: from CSI_I_PARTIES
10011: where instance_id = l_rel_tbl(j).subject_id
10012: and relationship_type_code = 'OWNER';
10013: Exception
10014: when no_data_found then

Line 10760: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP

10756: AND object_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10757: UNION ALL
10758:
10759: SELECT CIPH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
10760: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP
10761: WHERE CIPH.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
10762: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10763: UNION ALL
10764:

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

Line 11491: FROM csi_i_parties

11487: NULL CALL_CONTRACTS,
11488: NULL INTERFACE_ID,
11489: NULL CONTACT_PARENT_TBL_INDEX,
11490: NULL CASCADE_OWNERSHIP_FLAG -- Added for bug 2972082
11491: FROM csi_i_parties
11492: WHERE instance_id = p_instance_id
11493: AND relationship_type_code = 'OWNER';
11494:
11495:

Line 29048: FROM csi_i_parties cip

29044: --
29045: BEGIN
29046: SELECT cip.party_id
29047: INTO l_party_id
29048: FROM csi_i_parties cip
29049: WHERE cip.instance_id = x_new_instance_tbl(1).instance_id
29050: AND cip.relationship_type_code = 'OWNER';
29051: EXCEPTION
29052: WHEN OTHERS THEN

Line 33804: FROM csi_i_parties cip

33800:
33801: BEGIN
33802: SELECT cip.party_id
33803: INTO l_party_id
33804: FROM csi_i_parties cip
33805: WHERE cip.instance_id = x_new_instance_tbl(1).instance_id
33806: AND cip.relationship_type_code = 'OWNER';
33807: EXCEPTION
33808: WHEN OTHERS THEN