APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_I_ASSETS

Line 3253: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||

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, '||
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 '||

Line 10766: FROM CSI_I_ASSETS_H CIAAH, CSI_I_ASSETS CIAA

10762: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10763: UNION ALL
10764:
10765: SELECT CIAAH.TRANSACTION_ID TRANSACTION_ID, CIAA.INSTANCE_ID INSTANCE_ID
10766: FROM CSI_I_ASSETS_H CIAAH, CSI_I_ASSETS CIAA
10767: WHERE CIAAH.INSTANCE_ASSET_ID = CIAA.INSTANCE_ASSET_ID
10768: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10769: UNION ALL
10770:

Line 21555: FROM csi_i_assets

21551:
21552: BEGIN
21553: SELECT 1
21554: INTO l_dummy
21555: FROM csi_i_assets
21556: WHERE instance_id =p_source_instance_rec.instance_id;
21557:
21558: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
21559: FND_MSG_PUB.ADD;

Line 22054: FROM csi_i_assets

22050:
22051: BEGIN
22052: SELECT 1
22053: INTO l_dummy
22054: FROM csi_i_assets
22055: WHERE instance_id =p_source_instance_rec.instance_id;
22056:
22057: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
22058: FND_MSG_PUB.ADD;