eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INTERFACE_PKG dependencies on CSI_ITEM_INSTANCES

Line 2051: FROM csi_item_instances

2047: l_instance_found := TRUE;
2048: ELSE
2049: BEGIN
2050: SELECT 'Y' INTO l_dummy
2051: FROM csi_item_instances
2052: WHERE config_inst_hdr_id = l_rltns_tbl(l_ind).obj_config_inst_hdr_id
2053: --AND config_inst_rev_num = l_rltns_tbl(l_ind).obj_config_inst_rev_num
2054: AND config_inst_item_id = l_rltns_tbl(l_ind).obj_config_inst_item_id;
2055:

Line 2087: FROM csi_item_instances

2083: l_instance_found := TRUE;
2084: ELSE
2085: BEGIN
2086: SELECT 'Y' INTO l_dummy
2087: FROM csi_item_instances
2088: WHERE config_inst_hdr_id = l_rltns_tbl(l_ind).sub_config_inst_hdr_id
2089: --AND config_inst_rev_num = l_rltns_tbl(l_ind).sub_config_inst_rev_num
2090: AND config_inst_item_id = l_rltns_tbl(l_ind).sub_config_inst_item_id;
2091:

Line 2309: FROM csi_item_instances

2305: /* query install base to figure out the instance for the base line revision if TLD did not return*/
2306: BEGIN
2307: SELECT instance_id
2308: INTO l_tld_tbl(l_ind).instance_id
2309: FROM csi_item_instances
2310: WHERE config_inst_hdr_id = l_tld_tbl(l_ind).config_inst_hdr_id
2311: AND config_inst_item_id = l_tld_tbl(l_ind).config_inst_item_id;
2312: l_tld_tbl(l_ind).instance_exists_flag := 'Y';
2313: EXCEPTION

Line 2385: FROM csi_item_instances

2381: csi_t_gen_utility_pvt.add(' NON SOURCE LINE ');
2382: BEGIN
2383: SELECT instance_id
2384: INTO l_tld_tbl(l_ind).instance_id
2385: FROM csi_item_instances
2386: WHERE config_inst_hdr_id = l_tld_tbl(l_ind).config_inst_hdr_id
2387: AND config_inst_item_id = l_tld_tbl(l_ind).config_inst_item_id;
2388: l_tld_tbl(l_ind).instance_exists_flag := 'Y';
2389: EXCEPTION

Line 3197: FROM csi_item_instances

3193: SELECT location_id ,
3194: location_type_code
3195: INTO l_location_id,
3196: l_location_type_code
3197: FROM csi_item_instances
3198: WHERE config_inst_hdr_id = partner_rec.inst_hdr_id
3199: AND config_inst_item_id = partner_rec.inst_item_id;
3200:
3201: l_partner_location_found := TRUE;

Line 3285: FROM csi_item_instances

3281: -- Added for bug 9900096 to set the vld_org_id correctly, instead of to g_miss_num by default (HYONLEE)
3282: BEGIN
3283: SELECT LAST_VLD_ORGANIZATION_ID
3284: INTO l_vld_organization_id
3285: FROM csi_item_instances
3286: WHERE instance_id = p_txn_line_dtl_rec.instance_id;
3287:
3288: EXCEPTION
3289: WHEN no_data_found THEN

Line 3295: FROM csi_item_instances

3291: END;
3292: BEGIN
3293: SELECT inv_master_organization_id
3294: INTO l_inv_master_organization_id
3295: FROM csi_item_instances
3296: WHERE instance_id = p_txn_line_dtl_rec.instance_id;
3297:
3298: EXCEPTION
3299: WHEN no_data_found THEN

Line 3376: FROM csi_item_instances

3372: IF nvl(l_i_rec.instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
3373: BEGIN
3374: SELECT instance_usage_code
3375: INTO l_instance_usage_code
3376: FROM csi_item_instances
3377: WHERE instance_id = l_i_rec.instance_id;
3378:
3379: EXCEPTION
3380: WHEN no_data_found THEN

Line 3754: FROM csi_item_instances

3750: active_end_date
3751: INTO px_instance_rec.object_version_number,
3752: px_instance_rec.serial_number,
3753: l_active_end_date
3754: FROM csi_item_instances
3755: WHERE instance_id = px_instance_rec.instance_id;
3756:
3757: px_instance_rec.active_start_date := fnd_api.g_miss_date;
3758:

Line 4011: FROM csi_item_instances

4007: ELSE
4008: BEGIN
4009: SELECT instance_id,active_end_date
4010: INTO l_sub_instance_id,l_sub_end_date --Fix for bug 5956280
4011: FROM csi_item_instances
4012: WHERE config_inst_hdr_id = l_r_tbl(l_ii_ind).sub_config_inst_hdr_id
4013: --AND config_inst_rev_num = l_r_tbl(l_ii_ind).sub_config_inst_rev_num
4014: AND config_inst_item_id = l_r_tbl(l_ii_ind).sub_config_inst_item_id;
4015: EXCEPTION

Line 4035: FROM csi_item_instances

4031: ELSE
4032: BEGIN
4033: SELECT instance_id,active_end_date
4034: INTO l_obj_instance_id,l_obj_end_date --Fix for bug 5956280
4035: FROM csi_item_instances
4036: WHERE config_inst_hdr_id = l_r_tbl(l_ii_ind).obj_config_inst_hdr_id
4037: --AND config_inst_rev_num = l_r_tbl(l_ii_ind).obj_config_inst_rev_num
4038: AND config_inst_item_id = l_r_tbl(l_ii_ind).obj_config_inst_item_id;
4039: EXCEPTION

Line 4668: FROM csi_item_instances

4664: -- Start adding code for FP of bug 6755897 - Reconcilation changes
4665: BEGIN
4666: SELECT 'N'
4667: INTO l_item_instance_expired
4668: FROM csi_item_instances
4669: WHERE instance_id = l_u_instance_rec.instance_id
4670: AND ((active_end_date IS NULL) OR (active_end_date >= SYSDATE));
4671: EXCEPTION
4672: WHEN NO_DATA_FOUND THEN

Line 5576: FROM csi_item_instances

5572: active_end_date
5573: INTO l_instance_rec.object_version_number,
5574: l_instance_rec.quantity,
5575: l_instance_rec.active_end_date
5576: FROM csi_item_instances
5577: WHERE instance_id = l_instance_rec.instance_id;
5578:
5579: IF l_instance_rec.active_end_date is not null THEN
5580: l_instance_rec.active_end_date := null;

Line 6228: FROM csi_item_instances

6224: SELECT owner_party_account_id,
6225: owner_party_id
6226: INTO l_owner_party_acct_id,
6227: l_owner_party_id
6228: FROM csi_item_instances
6229: WHERE instance_id = p_instance_id;
6230:
6231:
6232: IF l_owner_party_id is not null THEN

Line 6363: FROM csi_item_instances

6359: /* moved this code out from interface IB */
6360: BEGIN
6361: SELECT instance_id
6362: INTO l_td_tbl(l_td_ind).instance_id
6363: FROM csi_item_instances
6364: WHERE config_inst_hdr_id = l_td_tbl(l_td_ind).config_inst_hdr_id
6365: AND config_inst_item_id = l_td_tbl(l_td_ind).config_inst_item_id;
6366:
6367: l_td_tbl(l_td_ind).instance_exists_flag := 'Y';