APPS.CSI_ML_CREATE_PVT dependencies on CSI_I_ASSET_INTERFACE

Line 91: FROM csi_i_asset_interface csia

87:
88: --bnarayan added for open interface
89: CURSOR c_assets(pc_interface_id in NUMBER) IS
90: SELECT csia.*
91: FROM csi_i_asset_interface csia
92: WHERE csia.inst_interface_id = pc_interface_id;
93:
94: r_attr c_attr%rowtype;
95: l_int_party NUMBER;

Line 158: ,csi_i_asset_interface ciai

154: AND cii.source_system_name = p_source_system_name
155: AND trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
156: AND exists ( SELECT 1
157: FROM csi_i_party_interface cipi
158: ,csi_i_asset_interface ciai
159: WHERE cipi.inst_interface_id = ciai.inst_interface_id
160: AND cipi.inst_interface_id = cii.inst_interface_id
161: AND nvl(cipi.party_id,0) <> l_int_party
162: AND cipi.party_relationship_type_code = 'OWNER'

Line 181: FROM csi_i_asset_interface ciai

177: AND cii.process_status = 'X'
178: AND cii.source_system_name = p_source_system_name
179: AND trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
180: AND exists (SELECT 1
181: FROM csi_i_asset_interface ciai
182: WHERE cii.inst_interface_id = ciai.inst_interface_id
183: AND ciai.fa_asset_id IS NULL
184: AND ciai.fa_asset_number IS NULL
185: );

Line 213: FROM csi_i_asset_interface ciai

209: AND nvl(cipi.party_id,0) = l_int_party
210: AND cipi.party_relationship_type_code = 'OWNER'
211: )
212: AND not exists (SELECT 1
213: FROM csi_i_asset_interface ciai
214: WHERE cii.inst_interface_id = ciai.inst_interface_id
215: ));
216:
217: IF SQL%FOUND THEN