APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on CSI_I_PARTY_INTERFACE

Line 30: csi_i_party_interface d

26: SELECT a.instance_id
27: FROM csi_item_instances a,
28: csi_i_parties b,
29: csi_instance_interface c,
30: csi_i_party_interface d
31: WHERE a.instance_id = b.instance_id
32: AND a.inventory_item_id = c.inventory_item_id
33: AND c.inst_interface_id = d.inst_interface_id
34: AND c.inst_interface_id = p_interface_id

Line 218: FROM csi_i_party_interface cpi

214: AND cii.process_status = 'R';
215:
216: CURSOR iparty_det_cur(p_inst_interface_id IN NUMBER) IS
217: SELECT cpi.*
218: FROM csi_i_party_interface cpi
219: WHERE cpi.inst_interface_id = p_inst_interface_id;
220:
221: CURSOR ieav_det_cur(p_inst_interface_id IN NUMBER) IS
222: SELECT ci.*

Line 492: FROM csi_i_party_interface cipi

488: AND cii.source_system_name = p_source_system_name
489: 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))
490: AND cii.process_status = 'R'
491: AND exists ( SELECT 1
492: FROM csi_i_party_interface cipi
493: ,csi_i_asset_interface ciai
494: WHERE cipi.inst_interface_id = ciai.inst_interface_id
495: AND cipi.inst_interface_id = cii.inst_interface_id
496: AND nvl(cipi.party_id,0) <> g_int_party

Line 544: FROM csi_i_party_interface cipi

540: 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))
541: AND cii.process_status = 'R'
542: AND cii.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
543: AND (exists (SELECT 1
544: FROM csi_i_party_interface cipi
545: WHERE cipi.inst_interface_id = cii.inst_interface_id
546: AND nvl(cipi.party_id,0) = g_int_party
547: AND cipi.party_relationship_type_code = 'OWNER'
548: )