APPS.CSI_INTERFACE_PKG dependencies on CSI_ITEM_INSTANCES

Line 2022: FROM csi_item_instances

2018: l_instance_found := TRUE;
2019: ELSE
2020: BEGIN
2021: SELECT 'Y' INTO l_dummy
2022: FROM csi_item_instances
2023: WHERE config_inst_hdr_id = l_rltns_tbl(l_ind).obj_config_inst_hdr_id
2024: --AND config_inst_rev_num = l_rltns_tbl(l_ind).obj_config_inst_rev_num
2025: AND config_inst_item_id = l_rltns_tbl(l_ind).obj_config_inst_item_id;
2026:

Line 2058: FROM csi_item_instances

2054: l_instance_found := TRUE;
2055: ELSE
2056: BEGIN
2057: SELECT 'Y' INTO l_dummy
2058: FROM csi_item_instances
2059: WHERE config_inst_hdr_id = l_rltns_tbl(l_ind).sub_config_inst_hdr_id
2060: --AND config_inst_rev_num = l_rltns_tbl(l_ind).sub_config_inst_rev_num
2061: AND config_inst_item_id = l_rltns_tbl(l_ind).sub_config_inst_item_id;
2062:

Line 2280: FROM csi_item_instances

2276: /* query install base to figure out the instance for the base line revision if TLD did not return*/
2277: BEGIN
2278: SELECT instance_id
2279: INTO l_tld_tbl(l_ind).instance_id
2280: FROM csi_item_instances
2281: WHERE config_inst_hdr_id = l_tld_tbl(l_ind).config_inst_hdr_id
2282: AND config_inst_item_id = l_tld_tbl(l_ind).config_inst_item_id;
2283: l_tld_tbl(l_ind).instance_exists_flag := 'Y';
2284: EXCEPTION

Line 2356: FROM csi_item_instances

2352: csi_t_gen_utility_pvt.add(' NON SOURCE LINE ');
2353: BEGIN
2354: SELECT instance_id
2355: INTO l_tld_tbl(l_ind).instance_id
2356: FROM csi_item_instances
2357: WHERE config_inst_hdr_id = l_tld_tbl(l_ind).config_inst_hdr_id
2358: AND config_inst_item_id = l_tld_tbl(l_ind).config_inst_item_id;
2359: l_tld_tbl(l_ind).instance_exists_flag := 'Y';
2360: EXCEPTION

Line 3163: FROM csi_item_instances

3159: SELECT location_id ,
3160: location_type_code
3161: INTO l_location_id,
3162: l_location_type_code
3163: FROM csi_item_instances
3164: WHERE config_inst_hdr_id = partner_rec.inst_hdr_id
3165: AND config_inst_item_id = partner_rec.inst_item_id;
3166:
3167: l_partner_location_found := TRUE;

Line 3293: FROM csi_item_instances

3289: IF nvl(l_i_rec.instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
3290: BEGIN
3291: SELECT instance_usage_code
3292: INTO l_instance_usage_code
3293: FROM csi_item_instances
3294: WHERE instance_id = l_i_rec.instance_id;
3295:
3296: EXCEPTION
3297: WHEN no_data_found THEN

Line 3662: FROM csi_item_instances

3658: active_end_date
3659: INTO px_instance_rec.object_version_number,
3660: px_instance_rec.serial_number,
3661: l_active_end_date
3662: FROM csi_item_instances
3663: WHERE instance_id = px_instance_rec.instance_id;
3664:
3665: px_instance_rec.active_start_date := fnd_api.g_miss_date;
3666:

Line 3919: FROM csi_item_instances

3915: ELSE
3916: BEGIN
3917: SELECT instance_id,active_end_date
3918: INTO l_sub_instance_id,l_sub_end_date --Fix for bug 5956280
3919: FROM csi_item_instances
3920: WHERE config_inst_hdr_id = l_r_tbl(l_ii_ind).sub_config_inst_hdr_id
3921: --AND config_inst_rev_num = l_r_tbl(l_ii_ind).sub_config_inst_rev_num
3922: AND config_inst_item_id = l_r_tbl(l_ii_ind).sub_config_inst_item_id;
3923: EXCEPTION

Line 3943: FROM csi_item_instances

3939: ELSE
3940: BEGIN
3941: SELECT instance_id,active_end_date
3942: INTO l_obj_instance_id,l_obj_end_date --Fix for bug 5956280
3943: FROM csi_item_instances
3944: WHERE config_inst_hdr_id = l_r_tbl(l_ii_ind).obj_config_inst_hdr_id
3945: --AND config_inst_rev_num = l_r_tbl(l_ii_ind).obj_config_inst_rev_num
3946: AND config_inst_item_id = l_r_tbl(l_ii_ind).obj_config_inst_item_id;
3947: EXCEPTION

Line 4561: FROM csi_item_instances

4557: -- Start adding code for FP of bug 6755897 - Reconcilation changes
4558: BEGIN
4559: SELECT 'N'
4560: INTO l_item_instance_expired
4561: FROM csi_item_instances
4562: WHERE instance_id = l_u_instance_rec.instance_id
4563: AND ((active_end_date IS NULL) OR (active_end_date >= SYSDATE));
4564: EXCEPTION
4565: WHEN NO_DATA_FOUND THEN

Line 5469: FROM csi_item_instances

5465: active_end_date
5466: INTO l_instance_rec.object_version_number,
5467: l_instance_rec.quantity,
5468: l_instance_rec.active_end_date
5469: FROM csi_item_instances
5470: WHERE instance_id = l_instance_rec.instance_id;
5471:
5472: IF l_instance_rec.active_end_date is not null THEN
5473: l_instance_rec.active_end_date := null;

Line 6121: FROM csi_item_instances

6117: SELECT owner_party_account_id,
6118: owner_party_id
6119: INTO l_owner_party_acct_id,
6120: l_owner_party_id
6121: FROM csi_item_instances
6122: WHERE instance_id = p_instance_id;
6123:
6124:
6125: IF l_owner_party_id is not null THEN

Line 6256: FROM csi_item_instances

6252: /* moved this code out from interface IB */
6253: BEGIN
6254: SELECT instance_id
6255: INTO l_td_tbl(l_td_ind).instance_id
6256: FROM csi_item_instances
6257: WHERE config_inst_hdr_id = l_td_tbl(l_td_ind).config_inst_hdr_id
6258: AND config_inst_item_id = l_td_tbl(l_td_ind).config_inst_item_id;
6259:
6260: l_td_tbl(l_td_ind).instance_exists_flag := 'Y';