APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CSP_PRODUCT_TASKS

Line 4150: CSP_PRODUCT_TASKS a,

4146: ROSC.RO_Service_code_id
4147: FROM CSD_RO_SERVICE_CODES ROSC,
4148: CSD_SERVICE_CODES_VL SC,
4149: CSD_SC_WORK_ENTITIES WRK,
4150: CSP_PRODUCT_TASKS a,
4151: CSP_TASK_PARTS b,
4152: QP_PRICE_LIST_LINES_V c,
4153: MTL_SYSTEM_ITEMS_KFV d,
4154: CSD_REPAIR_TYPES_SAR e,

Line 4263: csp_product_tasks a,

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,
4267: csd_repair_types_sar e,

Line 4389: CSP_PRODUCT_TASKS a,

4385: ROSC.RO_Service_code_id
4386: FROM CSD_RO_SERVICE_CODES ROSC,
4387: CSD_SERVICE_CODES_VL SC,
4388: CSD_SC_WORK_ENTITIES WRK,
4389: CSP_PRODUCT_TASKS a,
4390: CSP_TASK_PARTS b,
4391: -- QP_PRICE_LIST_LINES_V c,
4392: MTL_SYSTEM_ITEMS_KFV d,
4393: CSD_REPAIR_TYPES_SAR e,

Line 4500: csp_product_tasks a,

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,
4504: CSD_REPAIR_TYPES_SAR e,

Line 4637: FROM csp_product_tasks x,

4633: AND csd.est_line_source_type_code = 'SOLUTION'
4634: AND csd.est_line_source_id1 = KBSets.set_id)
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