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 3002: FROM csi_item_instances a, csi_i_assets b

2998: l_dup_flag BOOLEAN;
2999:
3000: CURSOR c_item_instances ( p_fa_asset_id NUMBER, p_fa_location_id NUMBER) IS
3001: SELECT a.instance_id,null inst_interface_id, a.quantity, a.location_id ,a.location_type_code
3002: FROM csi_item_instances a, csi_i_assets b
3003: WHERE a.instance_id = b.instance_id
3004: AND b.fa_asset_id = p_fa_asset_id
3005: AND b.fa_location_id = p_fa_location_id ;
3006:

Line 3019: FROM csi_item_instances a, csi_i_assets b

3015: AND a.process_status IN ('R','X')
3016: AND a.source_system_name = nvl(p_source_system_name ,a.source_system_name)
3017: UNION ALL
3018: SELECT a.instance_id,null inst_interface_id, a.quantity, a.location_id ,a.location_type_code
3019: FROM csi_item_instances a, csi_i_assets b
3020: WHERE a.instance_id = b.instance_id
3021: AND b.fa_asset_id = p_fa_asset_id
3022: AND b.fa_location_id = p_fa_location_id
3023: AND NOT EXISTS ( SELECT 1 FROM csi_instance_interface c

Line 3172: FROM csi_item_instances a, csi_i_assets b

3168: l_sql_stmt VARCHAR2(32767) ;
3169: l_asset_cnt NUMBER;
3170: CURSOR c_instance_assets( p_instance_id NUMBER ) IS
3171: SELECT b.fa_asset_id,b.fa_location_id, b.asset_quantity
3172: FROM csi_item_instances a, csi_i_assets b
3173: WHERE a.instance_id = b.instance_id
3174: AND a.instance_id = p_instance_id ;
3175:
3176: CURSOR c_interface_assets( p_instance_id NUMBER

Line 3189: FROM csi_item_instances a, csi_i_assets b

3185: OR a.inst_interface_id = p_interface_id )
3186: AND a.source_system_name = nvl(p_source_system_name,a.source_system_name)
3187: UNION ALL
3188: SELECT b.fa_asset_id,b.fa_location_id, b.asset_quantity
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,