eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on JTF_TASK_TEMPLATES_VL

Line 4122: JTF_TASK_TEMPLATES_VL g

4118: QP_PRICE_LIST_LINES_V c,
4119: MTL_SYSTEM_ITEMS_KFV d,
4120: CSD_REPAIR_TYPES_SAR e,
4121: CS_TXN_BILLING_TYPES f,
4122: JTF_TASK_TEMPLATES_VL g
4123: WHERE ROSC.repair_line_id = p_repair_line_id
4124: and ROSC.applicable_flag = 'Y'
4125: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4126: and ROSC.applied_to_est_flag = 'N'

Line 4176: JTF_TASK_TEMPLATES_VL g

4172: QP_PRICE_LIST_LINES_V c,
4173: MTL_SYSTEM_ITEMS_KFV d,
4174: CSD_REPAIR_TYPES_SAR e,
4175: CS_TXN_BILLING_TYPES f,
4176: JTF_TASK_TEMPLATES_VL g
4177: WHERE ROSC.repair_line_id = p_repair_line_id
4178: and ROSC.applicable_flag = 'Y'
4179: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4180: and ROSC.applied_to_est_flag = 'N'

Line 4235: jtf_task_templates_vl g

4231: qp_price_list_lines_v c,
4232: mtl_system_items_kfv d,
4233: csd_repair_types_sar e,
4234: cs_txn_billing_types f,
4235: jtf_task_templates_vl g
4236: WHERE
4237: g.task_group_id = JtfTaskTempGroupEO.task_template_group_id
4238: and a.task_template_id = g.task_template_id
4239: and a.product_id = p_inventory_item_id

Line 4300: jtf_task_templates_vl g

4296: qp_price_list_lines_v c,
4297: mtl_system_items_kfv d,
4298: csd_repair_types_sar e,
4299: cs_txn_billing_types f,
4300: jtf_task_templates_vl g
4301: WHERE
4302: SetLinkRO.other_id = p_repair_line_id
4303: and SetLinkRO.object_code = 'DR'
4304: and SetLinkRO.link_type = 'S'

Line 4361: JTF_TASK_TEMPLATES_VL g

4357: -- QP_PRICE_LIST_LINES_V c,
4358: MTL_SYSTEM_ITEMS_KFV d,
4359: CSD_REPAIR_TYPES_SAR e,
4360: CS_TXN_BILLING_TYPES f,
4361: JTF_TASK_TEMPLATES_VL g
4362: WHERE ROSC.repair_line_id = p_repair_line_id
4363: AND ROSC.applicable_flag = 'Y'
4364: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4365: AND ROSC.applied_to_est_flag = 'N'

Line 4416: JTF_TASK_TEMPLATES_VL g

4412: -- QP_PRICE_LIST_LINES_V c,
4413: MTL_SYSTEM_ITEMS_KFV d,
4414: CSD_REPAIR_TYPES_SAR e,
4415: CS_TXN_BILLING_TYPES f,
4416: JTF_TASK_TEMPLATES_VL g
4417: WHERE ROSC.repair_line_id = p_repair_line_id
4418: AND ROSC.applicable_flag = 'Y'
4419: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4420: AND ROSC.applied_to_est_flag = 'N'

Line 4472: jtf_task_templates_vl g

4468: -- qp_price_list_lines_v c,
4469: mtl_system_items_kfv d,
4470: CSD_REPAIR_TYPES_SAR e,
4471: cs_txn_billing_types f,
4472: jtf_task_templates_vl g
4473: WHERE g.task_group_id =
4474: JtfTaskTempGroupEO.task_template_group_id
4475: AND a.task_template_id = g.task_template_id
4476: AND a.product_id = p_inventory_item_id

Line 4536: jtf_task_templates_vl g

4532: -- qp_price_list_lines_v c,
4533: mtl_system_items_kfv d,
4534: CSD_REPAIR_TYPES_SAR e,
4535: cs_txn_billing_types f,
4536: jtf_task_templates_vl g
4537: WHERE SetLinkRO.other_id = p_repair_line_id
4538: AND SetLinkRO.object_code = 'DR'
4539: AND SetLinkRO.link_type = 'S'
4540: AND SetLinkTG.set_id = SetLinkRO.set_id

Line 4604: jtf_task_templates_vl y,

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
4608: AND y.task_group_id = SetLinkTG.other_id);