APPS.CSI_ASSET_PVT dependencies on CSI_I_ASSET_INTERFACE

Line 3011: FROM csi_instance_interface a ,csi_i_asset_interface b

3007: CURSOR c_interf_instance ( p_fa_asset_id NUMBER,
3008: p_fa_location_id NUMBER,
3009: p_source_system_name VARCHAR2 ) IS
3010: SELECT a.instance_id,a.inst_interface_id,a.quantity, a.location_id ,a.location_type_code
3011: FROM csi_instance_interface a ,csi_i_asset_interface b
3012: WHERE a.inst_interface_id=b.inst_interface_id
3013: AND b.fa_asset_id = p_fa_asset_id
3014: AND b.fa_location_id = p_fa_location_id
3015: AND a.process_status IN ('R','X')

Line 3181: FROM csi_instance_interface a ,csi_i_asset_interface b

3177: ,p_interface_id NUMBER
3178: ,p_source_system_name VARCHAR2
3179: ) IS
3180: SELECT b.fa_asset_id,b.fa_location_id,b.asset_quantity
3181: FROM csi_instance_interface a ,csi_i_asset_interface b
3182: WHERE a.inst_interface_id = b.inst_interface_id
3183: AND a.process_status IN ('R','X')
3184: AND (a.instance_id = p_instance_id
3185: OR a.inst_interface_id = p_interface_id )

Line 3193: FROM csi_i_asset_interface c,

3189: FROM csi_item_instances a, csi_i_assets b
3190: WHERE a.instance_id = b.instance_id
3191: AND a.instance_id = p_instance_id
3192: AND NOT EXISTS ( SELECT 1
3193: FROM csi_i_asset_interface c,
3194: csi_instance_interface d
3195: WHERE d.instance_id = a.instance_id
3196: AND c.inst_interface_id = d.inst_interface_id
3197: AND d.source_system_name = nvl(p_source_system_name,d.source_system_name)