DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CS_KB_SET_LINKS

Line 4225: cs_kb_set_links SetLinkTG, --link to task group

4221: SetLinkRO.set_id est_line_source_id1,
4222: null est_line_source_id2,
4223: null ro_service_code_id
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,

Line 4226: cs_kb_set_links SetLinkRO, -- link to repair order

4222: null est_line_source_id2,
4223: null ro_service_code_id
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,

Line 4291: cs_kb_set_links SetLinkTG, --link to task group

4287: SetLinkRO.set_id est_line_source_id1,
4288: null est_line_source_id2,
4289: null ro_service_code_id
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,

Line 4292: cs_kb_set_links SetLinkRO, -- link to repair order

4288: null est_line_source_id2,
4289: null ro_service_code_id
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,

Line 4462: FROM cs_kb_set_links SetLinkTG, --link to task group

4458: 'SOLUTION' est_line_source_type_code,
4459: SetLinkRO.set_id est_line_source_id1,
4460: NULL est_line_source_id2,
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,

Line 4463: cs_kb_set_links SetLinkRO, -- link to repair order

4459: SetLinkRO.set_id est_line_source_id1,
4460: NULL est_line_source_id2,
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,

Line 4527: FROM cs_kb_set_links SetLinkTG, --link to task group

4523: 'SOLUTION' est_line_source_type_code,
4524: SetLinkRO.set_id est_line_source_id1,
4525: NULL est_line_source_id2,
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,

Line 4528: cs_kb_set_links SetLinkRO, -- link to repair order

4524: SetLinkRO.set_id est_line_source_id1,
4525: NULL est_line_source_id2,
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,

Line 4579: FROM cs_kb_set_links SetLinkTG, --link to task group

4575: CURSOR c_sol_tasks_no_prod(p_repair_line_id NUMBER) IS
4576: SELECT KBSets.set_id solution_id, -- solution id
4577: JtfTaskTempGroupEO.task_template_group_id task_group_id, -- task template group id
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

Line 4580: cs_kb_set_links SetLinkRO, -- link to repair order

4576: SELECT KBSets.set_id solution_id, -- solution id
4577: JtfTaskTempGroupEO.task_template_group_id task_group_id, -- task template group id
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