APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CSP_PRODUCT_TASKS

Line 4116: CSP_PRODUCT_TASKS a,

4112: ROSC.RO_Service_code_id
4113: FROM CSD_RO_SERVICE_CODES ROSC,
4114: CSD_SERVICE_CODES_VL SC,
4115: CSD_SC_WORK_ENTITIES WRK,
4116: CSP_PRODUCT_TASKS a,
4117: CSP_TASK_PARTS b,
4118: QP_PRICE_LIST_LINES_V c,
4119: MTL_SYSTEM_ITEMS_KFV d,
4120: CSD_REPAIR_TYPES_SAR e,

Line 4229: csp_product_tasks a,

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

Line 4355: CSP_PRODUCT_TASKS a,

4351: ROSC.RO_Service_code_id
4352: FROM CSD_RO_SERVICE_CODES ROSC,
4353: CSD_SERVICE_CODES_VL SC,
4354: CSD_SC_WORK_ENTITIES WRK,
4355: CSP_PRODUCT_TASKS a,
4356: CSP_TASK_PARTS b,
4357: -- QP_PRICE_LIST_LINES_V c,
4358: MTL_SYSTEM_ITEMS_KFV d,
4359: CSD_REPAIR_TYPES_SAR e,

Line 4466: csp_product_tasks a,

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

Line 4603: FROM csp_product_tasks x,

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