APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on JTF_TASK_TEMP_GROUPS_VL

Line 4228: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4224: FROM
4225: cs_kb_set_links SetLinkTG, --link to task group
4226: cs_kb_set_links SetLinkRO, -- link to repair order
4227: cs_kb_sets_vl KBSets,
4228: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4229: csp_product_tasks a,
4230: csp_task_parts b,
4231: qp_price_list_lines_v c,
4232: mtl_system_items_kfv d,

Line 4294: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4290: FROM
4291: cs_kb_set_links SetLinkTG, --link to task group
4292: cs_kb_set_links SetLinkRO, -- link to repair order
4293: cs_kb_sets_vl KBSets,
4294: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4295: jtf_task_templates_b b,
4296: qp_price_list_lines_v c,
4297: mtl_system_items_kfv d,
4298: csd_repair_types_sar e,

Line 4465: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4461: NULL ro_service_code_id
4462: FROM cs_kb_set_links SetLinkTG, --link to task group
4463: cs_kb_set_links SetLinkRO, -- link to repair order
4464: cs_kb_sets_vl KBSets,
4465: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4466: csp_product_tasks a,
4467: csp_task_parts b,
4468: -- qp_price_list_lines_v c,
4469: mtl_system_items_kfv d,

Line 4530: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4526: NULL ro_service_code_id
4527: FROM cs_kb_set_links SetLinkTG, --link to task group
4528: cs_kb_set_links SetLinkRO, -- link to repair order
4529: cs_kb_sets_vl KBSets,
4530: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4531: jtf_task_templates_b b,
4532: -- qp_price_list_lines_v c,
4533: mtl_system_items_kfv d,
4534: CSD_REPAIR_TYPES_SAR e,

Line 4582: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4578: JtfTaskTempGroupEO.template_group_name task_group_name -- task template group name
4579: FROM cs_kb_set_links SetLinkTG, --link to task group
4580: cs_kb_set_links SetLinkRO, -- link to repair order
4581: cs_kb_sets_vl KBSets,
4582: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4583: CSD_REPAIRS repairs
4584: WHERE SetLinkRO.other_id = p_repair_line_id
4585: AND SetLinkRO.object_code = 'DR'
4586: AND SetLinkRO.link_type = 'S'

Line 4605: jtf_task_temp_groups_vl z

4601: AND NOT EXISTS -- no template for this product
4602: (SELECT 'x'
4603: FROM csp_product_tasks x,
4604: jtf_task_templates_vl y,
4605: jtf_task_temp_groups_vl z
4606: WHERE x.product_id = repairs.inventory_item_id
4607: AND x.task_template_id = y.task_template_id
4608: AND y.task_group_id = SetLinkTG.other_id);
4609: