DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_POPULATE_PVT dependencies on JTF_TASK_TYPES_B

Line 31: jtf_task_types_b ttype

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
32: WHERE j.task_id = l_task_id
33: AND j.SOURCE_OBJECT_TYPE_CODE = 'SR'
34: AND i.incident_id = j.SOURCE_OBJECT_ID
35: AND p.product_id = i.inventory_item_id

Line 47: jtf_task_types_b ttype

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
48: WHERE jtb.task_id = l_task_id
49: AND jtb.SOURCE_OBJECT_TYPE_CODE = 'DR'
50: AND cr.repair_line_id = jtb.SOURCE_OBJECT_ID
51: AND cpp.product_id = cr.inventory_item_id