APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on JTF_TASK_TEMP_GROUPS_VL

Line 4262: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4258: FROM
4259: cs_kb_set_links SetLinkTG, --link to task group
4260: cs_kb_set_links SetLinkRO, -- link to repair order
4261: cs_kb_sets_vl KBSets,
4262: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4263: csp_product_tasks a,
4264: csp_task_parts b,
4265: qp_price_list_lines_v c,
4266: mtl_system_items_kfv d,

Line 4328: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4324: FROM
4325: cs_kb_set_links SetLinkTG, --link to task group
4326: cs_kb_set_links SetLinkRO, -- link to repair order
4327: cs_kb_sets_vl KBSets,
4328: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4329: jtf_task_templates_b b,
4330: qp_price_list_lines_v c,
4331: mtl_system_items_kfv d,
4332: csd_repair_types_sar e,

Line 4499: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4495: NULL ro_service_code_id
4496: FROM cs_kb_set_links SetLinkTG, --link to task group
4497: cs_kb_set_links SetLinkRO, -- link to repair order
4498: cs_kb_sets_vl KBSets,
4499: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4500: csp_product_tasks a,
4501: csp_task_parts b,
4502: -- qp_price_list_lines_v c,
4503: mtl_system_items_kfv d,

Line 4564: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4560: NULL ro_service_code_id
4561: FROM cs_kb_set_links SetLinkTG, --link to task group
4562: cs_kb_set_links SetLinkRO, -- link to repair order
4563: cs_kb_sets_vl KBSets,
4564: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4565: jtf_task_templates_b b,
4566: -- qp_price_list_lines_v c,
4567: mtl_system_items_kfv d,
4568: CSD_REPAIR_TYPES_SAR e,

Line 4616: jtf_task_temp_groups_vl JtfTaskTempGroupEO,

4612: JtfTaskTempGroupEO.template_group_name task_group_name -- task template group name
4613: FROM cs_kb_set_links SetLinkTG, --link to task group
4614: cs_kb_set_links SetLinkRO, -- link to repair order
4615: cs_kb_sets_vl KBSets,
4616: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4617: CSD_REPAIRS repairs
4618: WHERE SetLinkRO.other_id = p_repair_line_id
4619: AND SetLinkRO.object_code = 'DR'
4620: AND SetLinkRO.link_type = 'S'

Line 4639: jtf_task_temp_groups_vl z

4635: AND NOT EXISTS -- no template for this product
4636: (SELECT 'x'
4637: FROM csp_product_tasks x,
4638: jtf_task_templates_vl y,
4639: jtf_task_temp_groups_vl z
4640: WHERE x.product_id = repairs.inventory_item_id
4641: AND x.task_template_id = y.task_template_id
4642: AND y.task_group_id = SetLinkTG.other_id);
4643: