APPS.MSD_SOP_FACT_DATA dependencies on MSD_CS_DEFINITIONS

Line 29: from msd_cs_definitions

25:
26:
27: cursor get_cs_defn_id_c1(l_cs_name IN Varchar2) IS
28: select cs_definition_id
29: from msd_cs_definitions
30: where name = l_cs_name;
31:
32: l_cs_name cs_name_list;
33: l_date_from varchar2(30);

Line 178: from msd_cs_definitions

174: l_cs_name_desc := null;
175:
176: select description
177: into l_cs_name_desc
178: from msd_cs_definitions
179: where cs_definition_id = l_cs_definition_id;
180:
181: /* Get Collection request id */
182: l_req_num := 0;

Line 261: from msd_cs_definitions

257: ) is
258:
259: cursor get_cs_defn_id_c2 IS
260: select cs_definition_id
261: from msd_cs_definitions
262: where name in ('MSD_TOTAL_BACKLOG', 'MSD_PASTDUE_BACKLOG', 'MSD_PRODUCTION_PLAN',
263: 'MSD_ACTUAL_PRODUCTION', 'MSD_ONHAND_INVENTORY');
264:
265: cursor get_cs_name_c2 (l_cs_definition_id IN number) IS

Line 267: from msd_cs_definitions

263: 'MSD_ACTUAL_PRODUCTION', 'MSD_ONHAND_INVENTORY');
264:
265: cursor get_cs_name_c2 (l_cs_definition_id IN number) IS
266: select name
267: from msd_cs_definitions
268: where cs_definition_id = l_cs_definition_id;
269:
270: l_cs_id cs_id_list;
271: l_req_num number;

Line 340: from msd_cs_definitions

336: l_cs_name_desc := null;
337:
338: select description
339: into l_cs_name_desc
340: from msd_cs_definitions
341: where cs_definition_id = l_cs_id(j).cs_definition_id;
342:
343: -- fnd_file.put_line(fnd_file.log, 'CS Name: '||l_cs_name);
344: -- fnd_file.put_line(fnd_file.log, 'CS Id: '||l_cs_id(j).cs_definition_id);