DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_POPULATE_PVT dependencies on JTF_TASKS_B

Line 27: FROM jtf_tasks_b j,

23:
24: CURSOR product_task_id(l_task_id NUMBER) IS
25: SELECT p.product_task_id,
26: p.ACTUAL_TIMES_USED
27: FROM jtf_tasks_b j,
28: CS_INCIDENTS_ALL_B i,
29: csp_product_tasks p,
30: JTF_TASK_TEMPLATES_B jtt,
31: jtf_task_types_b ttype

Line 43: FROM jtf_tasks_b jtb,

39: AND NVL(ttype.spares_allowed_flag, 'N') = 'Y'
40: UNION ALL
41: SELECT cpp.product_task_id,
42: cpp.ACTUAL_TIMES_USED
43: FROM jtf_tasks_b jtb,
44: csd_repairs cr,
45: csp_product_tasks cpp,
46: JTF_TASK_TEMPLATES_B jtt,
47: jtf_task_types_b ttype