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 200: from csf_debrief_lines cdl

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

Line 243: update csf_debrief_lines

239:
240:
241: end if;
242:
243: update csf_debrief_lines
244: set statistics_updated = 'Y',
245: last_updated_by = fnd_global.user_id,
246: last_update_date = sysdate
247: where debrief_line_id = cdl.debrief_line_id;

Line 295: from csf_debrief_lines cdl

291: order by ctp.actual_times_used desc;
292:
293: cursor debrief_line is
294: select DEBRIEF_LINE_ID
295: from csf_debrief_lines cdl
296: where INVENTORY_ITEM_ID = l_inventory_item_id
297: and debrief_header_id = p_debrief_header_id
298: and STATISTICS_UPDATED = 'Y' ;
299:

Line 455: from csf_debrief_lines cdl

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