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 1575: FROM csi_item_instances

1571:
1572: -- Current Object Version ID since the instance was Just Created
1573: SELECT object_version_number
1574: INTO l_curr_object_vers_61_id
1575: FROM csi_item_instances
1576: WHERE instance_id = l_expire_instance_rec.instance_id;
1577:
1578: l_expire_instance_rec.object_version_number := l_curr_object_vers_61_id;
1579:

Line 2137: FROM csi_item_instances

2133: r_intransit_line_id c_intransit_line_id%rowtype;
2134:
2135: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
2136: SELECT object_version_number
2137: FROM csi_item_instances
2138: WHERE instance_id = pc_instance_id;
2139:
2140: CURSOR c_so_info (pc_line_id in NUMBER) is
2141: SELECT oeh.header_id,

Line 4173: FROM csi_item_instances

4169: r_so_info c_so_info%rowtype;
4170:
4171: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
4172: SELECT object_version_number
4173: FROM csi_item_instances
4174: WHERE instance_id = pc_instance_id;
4175:
4176: CURSOR c_loc_ids (pc_org_id IN NUMBER,
4177: pc_subinv_name IN VARCHAR2) is