DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_POPULATE_PVT dependencies on CSD_REPAIRS

Line 34: FROM jtf_tasks_b jtb, csd_repairs cr,csp_product_tasks cpp

30: AND p.product_id = i.inventory_item_id
31: AND p.task_template_id = j.template_id
32: union all
33: SELECT product_task_id,ACTUAL_TIMES_USED
34: FROM jtf_tasks_b jtb, csd_repairs cr,csp_product_tasks cpp
35: WHERE jtb.task_id = l_task_id
36: AND jtb.SOURCE_OBJECT_TYPE_CODE = 'DR'
37: AND cr.repair_line_id = jtb.SOURCE_OBJECT_ID
38: AND cpp.product_id = cr.inventory_item_id