DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_POPULATE_PVT dependencies on CS_INCIDENTS_ALL_B

Line 26: FROM jtf_tasks_b j, CS_INCIDENTS_ALL_B i,csp_product_tasks p

22:
23:
24: CURSOR product_task_id(l_task_id NUMBER) IS
25: SELECT product_task_id,ACTUAL_TIMES_USED
26: FROM jtf_tasks_b j, CS_INCIDENTS_ALL_B i,csp_product_tasks p
27: WHERE j.task_id = l_task_id
28: AND j.SOURCE_OBJECT_TYPE_CODE = 'SR'
29: AND i.incident_id = j.SOURCE_OBJECT_ID
30: AND p.product_id = i.inventory_item_id