APPS.CSI_ASSET_PVT dependencies on CSI_INSTANCE_INTERFACE

Line 2987: FROM csi_instance_interface a ,csi_i_asset_interface b

2983: CURSOR c_interf_instance ( p_fa_asset_id NUMBER,
2984: p_fa_location_id NUMBER,
2985: p_source_system_name VARCHAR2 ) IS
2986: SELECT a.instance_id,a.inst_interface_id,a.quantity, a.location_id ,a.location_type_code
2987: FROM csi_instance_interface a ,csi_i_asset_interface b
2988: WHERE a.inst_interface_id=b.inst_interface_id
2989: AND b.fa_asset_id = p_fa_asset_id
2990: AND b.fa_location_id = p_fa_location_id
2991: AND a.process_status IN ('R','X')

Line 2999: AND NOT EXISTS ( SELECT 1 FROM csi_instance_interface c

2995: FROM csi_item_instances a, csi_i_assets b
2996: WHERE a.instance_id = b.instance_id
2997: AND b.fa_asset_id = p_fa_asset_id
2998: AND b.fa_location_id = p_fa_location_id
2999: AND NOT EXISTS ( SELECT 1 FROM csi_instance_interface c
3000: WHERE c.instance_id = a.instance_id
3001: AND c.process_status IN ('R','X')
3002: AND c.source_system_name = nvl(p_source_system_name ,c.source_system_name)) ;
3003:

Line 3157: FROM csi_instance_interface a ,csi_i_asset_interface b

3153: ,p_interface_id NUMBER
3154: ,p_source_system_name VARCHAR2
3155: ) IS
3156: SELECT b.fa_asset_id,b.fa_location_id,b.asset_quantity
3157: FROM csi_instance_interface a ,csi_i_asset_interface b
3158: WHERE a.inst_interface_id = b.inst_interface_id
3159: AND a.process_status IN ('R','X')
3160: AND (a.instance_id = p_instance_id
3161: OR a.inst_interface_id = p_interface_id )

Line 3170: csi_instance_interface d

3166: WHERE a.instance_id = b.instance_id
3167: AND a.instance_id = p_instance_id
3168: AND NOT EXISTS ( SELECT 1
3169: FROM csi_i_asset_interface c,
3170: csi_instance_interface d
3171: WHERE d.instance_id = a.instance_id
3172: AND c.inst_interface_id = d.inst_interface_id
3173: AND d.source_system_name = nvl(p_source_system_name,d.source_system_name)
3174: AND c.fa_asset_id = b.fa_asset_id