DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CS_KB_SET_LINKS

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

4255: SetLinkRO.set_id est_line_source_id1,
4256: null est_line_source_id2,
4257: null ro_service_code_id
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,

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

4256: null est_line_source_id2,
4257: null ro_service_code_id
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,

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

4321: SetLinkRO.set_id est_line_source_id1,
4322: null est_line_source_id2,
4323: null ro_service_code_id
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,

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

4322: null est_line_source_id2,
4323: null ro_service_code_id
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,

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

4492: 'SOLUTION' est_line_source_type_code,
4493: SetLinkRO.set_id est_line_source_id1,
4494: NULL est_line_source_id2,
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,

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

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

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

4557: 'SOLUTION' est_line_source_type_code,
4558: SetLinkRO.set_id est_line_source_id1,
4559: NULL est_line_source_id2,
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,

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

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

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

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

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

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