APPS.CSP_PROD_TASK_PARTS_HISTORY dependencies on CSF_DEBRIEF_LINES

Line 30: from csf_debrief_lines cdl,

26: cdl.item_revision,
27: cdh.statistics_updated,
28: cdh.debrief_header_id,
29: cdl.debrief_line_id
30: from csf_debrief_lines cdl,
31: csf_debrief_headers cdh,
32: jtf_task_assignments jta,
33: jtf_tasks_b jtb,
34: mtl_system_items_b msib,

Line 62: from csf_debrief_lines cdl

58: cursor c_existing_line(p_debrief_header_id number,
59: p_inventory_item_id number,
60: p_revision varchar2) is
61: select cdl.inventory_item_id
62: from csf_debrief_lines cdl
63: where cdl.debrief_header_id = p_debrief_header_id
64: and cdl.inventory_item_id = p_inventory_item_id
65: and nvl(cdl.item_revision,0) = nvl(p_revision,0)
66: and cdl.statistics_updated = 'Y';

Line 198: from csf_debrief_lines cdl

194: ,p_organization_id => NULL
195: ,x_replaced_item_list => l_replaced_items_list);
196: IF l_replaced_items_list IS NOT NULL THEN
197: l_sql_string := 'select cdl.inventory_item_id
198: from csf_debrief_lines cdl
199: where cdl.debrief_header_id = cdl.debrief_header_id
200: and cdl.inventory_item_id IN ' || l_replaced_items_list ||
201: 'or cdl.inventory_item_id = cdl.inventory_item_id
202: and cdl.statistics_updated = ' || '''' || 'Y' || '''';

Line 241: update csf_debrief_lines

237:
238:
239: end if;
240:
241: update csf_debrief_lines
242: set statistics_updated = 'Y'
243: where debrief_line_id = cdl.debrief_line_id;
244:
245: end loop;

Line 291: from csf_debrief_lines cdl

287: order by ctp.actual_times_used desc;
288:
289: cursor debrief_line is
290: select DEBRIEF_LINE_ID
291: from csf_debrief_lines cdl
292: where INVENTORY_ITEM_ID = l_inventory_item_id
293: and debrief_header_id = p_debrief_header_id
294: and STATISTICS_UPDATED = 'Y' ;
295:

Line 451: from csf_debrief_lines cdl

447: CSP_SUPERSESSIONS_PVT.get_replaced_items_list(p_inventory_item_id => l_supersede_item
448: ,p_organization_id => NULL
449: ,x_replaced_item_list => l_replaced_items_list);
450: l_sql_string := 'select DEBRIEF_LINE_ID
451: from csf_debrief_lines cdl
452: where INVENTORY_ITEM_ID IN ' || l_replaced_items_list ||
453: 'and debrief_header_id = ' || p_debrief_header_id ||
454: 'and STATISTICS_UPDATED =' || '''' || 'Y' || '''' ;
455: