APPS.CSI_ASSET_PVT dependencies on CSI_ITEM_INSTANCES

Line 128: FROM csi_item_instances cii

124: SELECT decode(cii.location_type_code,'HZ_PARTY_SITES',
125: (select hzp.location_id
126: from hz_party_sites hzp
127: where hzp.party_site_id = cii.location_id),cii.location_id) cii_location_id
128: FROM csi_item_instances cii
129: WHERE cii.instance_id = px_instance_asset_rec.instance_id;
130: --
131: CURSOR csi_a_location_cur IS
132: SELECT fa_location_id

Line 1165: -- Validate the Instance id exists in csi_item_instances

1161: ( p_instance_asset_rec.UPDATE_STATUS,
1162: ' p_instance_asset_rec.UPDATE_STATUS',
1163: l_api_name );
1164:
1165: -- Validate the Instance id exists in csi_item_instances
1166: IF p_called_from_grp <> FND_API.G_TRUE THEN
1167: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1168: (p_instance_asset_rec.INSTANCE_ID
1169: ,p_instance_asset_rec.check_for_instance_expiry

Line 1680: -- Validate the Instance id exists in csi_item_instances

1676: IF NOT( CSI_Asset_vld_pvt.Is_Inst_asset_id_valid (p_instance_asset_rec.INSTANCE_ASSET_ID)) THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: -- Validate the Instance id exists in csi_item_instances
1681: IF ((p_instance_asset_rec.INSTANCE_ID IS NOT NULL)
1682: AND (p_instance_asset_rec.INSTANCE_ID <> FND_API.G_MISS_NUM)) THEN
1683: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1684: (p_instance_asset_rec.INSTANCE_ID

Line 2374: --update the accounting class code in the csi_item_instances

2370:
2371: END;
2372: -- End of modification for Bug#2547034 on 09/20/02 - rtalluri
2373:
2374: --update the accounting class code in the csi_item_instances
2375: csi_item_instance_pvt.get_and_update_acct_class
2376: ( p_api_version => p_api_version
2377: ,p_commit => p_commit
2378: ,p_init_msg_list => p_init_msg_list

Line 2978: FROM csi_item_instances a, csi_i_assets b

2974: l_dup_flag BOOLEAN;
2975:
2976: CURSOR c_item_instances ( p_fa_asset_id NUMBER, p_fa_location_id NUMBER) IS
2977: SELECT a.instance_id,null inst_interface_id, a.quantity, a.location_id ,a.location_type_code
2978: FROM csi_item_instances a, csi_i_assets b
2979: WHERE a.instance_id = b.instance_id
2980: AND b.fa_asset_id = p_fa_asset_id
2981: AND b.fa_location_id = p_fa_location_id ;
2982:

Line 2995: FROM csi_item_instances a, csi_i_assets b

2991: AND a.process_status IN ('R','X')
2992: AND a.source_system_name = nvl(p_source_system_name ,a.source_system_name)
2993: UNION ALL
2994: SELECT a.instance_id,null inst_interface_id, a.quantity, a.location_id ,a.location_type_code
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

Line 3148: FROM csi_item_instances a, csi_i_assets b

3144: l_sql_stmt VARCHAR2(32767) ;
3145: l_asset_cnt NUMBER;
3146: CURSOR c_instance_assets( p_instance_id NUMBER ) IS
3147: SELECT b.fa_asset_id,b.fa_location_id, b.asset_quantity
3148: FROM csi_item_instances a, csi_i_assets b
3149: WHERE a.instance_id = b.instance_id
3150: AND a.instance_id = p_instance_id ;
3151:
3152: CURSOR c_interface_assets( p_instance_id NUMBER

Line 3165: FROM csi_item_instances a, csi_i_assets b

3161: OR a.inst_interface_id = p_interface_id )
3162: AND a.source_system_name = nvl(p_source_system_name,a.source_system_name)
3163: UNION ALL
3164: SELECT b.fa_asset_id,b.fa_location_id, b.asset_quantity
3165: FROM csi_item_instances a, csi_i_assets b
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,