APPS.CSI_UTL_PKG dependencies on CSI_ITEM_INSTANCES

Line 323: FROM csi_item_instances

319: SELECT object_version_number,
320: quantity
321: INTO x_obj_version_number,
322: x_inst_qty
323: FROM csi_item_instances
324: WHERE instance_id = p_instance_id;
325: -- Commented these predicates as part of fix for Bug 2985193
326: -- Because the get_item_instance is opened for expired instances also.
327: -- AND ((active_end_date is null ) OR

Line 1282: FROM csi_item_instances

1278: api_log('get_instance');
1279:
1280: SELECT instance_id
1281: INTO l_inst_id
1282: FROM csi_item_instances
1283: WHERE last_oe_order_line_id = p_order_line_id;
1284:
1285: RETURN l_inst_id;
1286: EXCEPTION

Line 1991: FROM csi_item_instances cii,

1987:
1988: CURSOR parent_inst_cur IS
1989: SELECT cii.instance_id,
1990: 'N' process_flag
1991: FROM csi_item_instances cii,
1992: oe_order_lines_all oel
1993: WHERE oel.line_id = p_parent_line_id
1994: AND cii.inventory_item_id = oel.inventory_item_id
1995: AND cii.last_oe_order_line_id = oel.line_id;

Line 2280: FROM csi_item_instances

2276: instance_usage_code
2277: INTO l_wip_job_id,
2278: l_location_type_code,
2279: l_instance_usage_code
2280: FROM csi_item_instances
2281: WHERE instance_id = rltns_rec.subject_id;
2282:
2283: IF l_instance_usage_code = 'IN_RELATIONSHIP' THEN
2284: debug(' configuration found. no explosion.');

Line 3222: csi_item_instances cii

3218: IS
3219: CURSOR iir_cur(p_object_id in number, p_item_id in number) IS
3220: SELECT cii.quantity alloc_quantity
3221: FROM csi_ii_relationships ciir,
3222: csi_item_instances cii
3223: WHERE ciir.object_id = p_object_id
3224: AND cii.instance_id = ciir.subject_id
3225: AND cii.inventory_item_id = p_item_id
3226: AND sysdate BETWEEN nvl(ciir.active_start_date, sysdate - 1)

Line 4280: FROM csi_item_instances

4276: SELECT object_version_number,
4277: location_type_code
4278: INTO l_object_version_number,
4279: l_location_code
4280: FROM csi_item_instances
4281: WHERE instance_id = l_old_instance_id;
4282:
4283: EXCEPTION
4284: WHEN no_data_found THEN

Line 4455: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir

4451: AND (active_end_date is null OR active_end_date >= sysdate);
4452:
4453: CURSOR check_instance_status(p_instance_id IN NUMBER) IS
4454: SELECT distinct instance_number
4455: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir
4456: WHERE owner_party_id NOT IN (SELECT internal_party_id
4457: FROM csi_install_parameters)
4458: AND (cii.instance_id = cir.object_id or cii.instance_id = cir.subject_id)
4459: AND cir.relationship_type_code = 'COMPONENT-OF'

Line 4467: FROM csi_item_instances_h

4463:
4464: CURSOR check_instance_history(p_instance_id IN NUMBER) IS
4465: SELECT instance_history_id, new_location_type_code,
4466: new_instance_status_id
4467: FROM csi_item_instances_h
4468: WHERE instance_id = p_instance_id
4469: ORDER BY instance_history_id desc;
4470:
4471: CURSOR rmarp_transfer_comp(p_instance_id IN NUMBER) IS

Line 4883: FROM csi_item_instances

4879: /* Check item location */
4880: BEGIN
4881: SELECT location_type_code
4882: INTO l_location_type_code
4883: FROM csi_item_instances
4884: WHERE instance_id = l_old_instance_id;
4885: EXCEPTION
4886: WHEN OTHERS THEN
4887: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');