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 224: FROM csi_i_party_interface cpi

220: AND cii.process_status = 'R';
221:
222: CURSOR iparty_det_cur(p_inst_interface_id IN NUMBER) IS
223: SELECT cpi.*
224: FROM csi_i_party_interface cpi
225: WHERE cpi.inst_interface_id = p_inst_interface_id;
226:
227: CURSOR ieav_det_cur(p_inst_interface_id IN NUMBER) IS
228: SELECT ci.*

Line 505: FROM csi_i_party_interface cipi

501: AND cii.source_system_name = p_source_system_name
502: 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))
503: AND cii.process_status = 'R'
504: AND exists ( SELECT 1
505: FROM csi_i_party_interface cipi
506: ,csi_i_asset_interface ciai
507: WHERE cipi.inst_interface_id = ciai.inst_interface_id
508: AND cipi.inst_interface_id = cii.inst_interface_id
509: AND nvl(cipi.party_id,0) <> g_int_party

Line 559: FROM csi_i_party_interface cipi

555: 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))
556: AND cii.process_status = 'R'
557: AND cii.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
558: AND (exists (SELECT 1
559: FROM csi_i_party_interface cipi
560: WHERE cipi.inst_interface_id = cii.inst_interface_id
561: AND nvl(cipi.party_id,0) = g_int_party
562: AND cipi.party_relationship_type_code = 'OWNER'
563: )