APPS.CSI_INV_ISO_PKG dependencies on CSI_ITEM_INSTANCES

Line 105: FROM csi_item_instances

101: r_id c_id%rowtype;
102:
103: cursor c_inst (pc_instance_id in NUMBER) is
104: SELECT instance_usage_code
105: FROM csi_item_instances
106: WHERE instance_id = pc_instance_id;
107:
108: r_inst c_inst%rowtype;
109:

Line 1571: FROM csi_item_instances

1567:
1568: -- Current Object Version ID since the instance was Just Created
1569: SELECT object_version_number
1570: INTO l_curr_object_vers_61_id
1571: FROM csi_item_instances
1572: WHERE instance_id = l_expire_instance_rec.instance_id;
1573:
1574: l_expire_instance_rec.object_version_number := l_curr_object_vers_61_id;
1575:

Line 2131: FROM csi_item_instances

2127: r_intransit_line_id c_intransit_line_id%rowtype;
2128:
2129: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
2130: SELECT object_version_number
2131: FROM csi_item_instances
2132: WHERE instance_id = pc_instance_id;
2133:
2134: CURSOR c_so_info (pc_line_id in NUMBER) is
2135: SELECT oeh.header_id,

Line 4151: FROM csi_item_instances

4147: r_so_info c_so_info%rowtype;
4148:
4149: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
4150: SELECT object_version_number
4151: FROM csi_item_instances
4152: WHERE instance_id = pc_instance_id;
4153:
4154: CURSOR c_loc_ids (pc_org_id IN NUMBER,
4155: pc_subinv_name IN VARCHAR2) is