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 4156: JTF_TASK_TEMPLATES_VL g

4152: QP_PRICE_LIST_LINES_V c,
4153: MTL_SYSTEM_ITEMS_KFV d,
4154: CSD_REPAIR_TYPES_SAR e,
4155: CS_TXN_BILLING_TYPES f,
4156: JTF_TASK_TEMPLATES_VL g
4157: WHERE ROSC.repair_line_id = p_repair_line_id
4158: and ROSC.applicable_flag = 'Y'
4159: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4160: and ROSC.applied_to_est_flag = 'N'

Line 4210: JTF_TASK_TEMPLATES_VL g

4206: QP_PRICE_LIST_LINES_V c,
4207: MTL_SYSTEM_ITEMS_KFV d,
4208: CSD_REPAIR_TYPES_SAR e,
4209: CS_TXN_BILLING_TYPES f,
4210: JTF_TASK_TEMPLATES_VL g
4211: WHERE ROSC.repair_line_id = p_repair_line_id
4212: and ROSC.applicable_flag = 'Y'
4213: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4214: and ROSC.applied_to_est_flag = 'N'

Line 4269: jtf_task_templates_vl g

4265: qp_price_list_lines_v c,
4266: mtl_system_items_kfv d,
4267: csd_repair_types_sar e,
4268: cs_txn_billing_types f,
4269: jtf_task_templates_vl g
4270: WHERE
4271: g.task_group_id = JtfTaskTempGroupEO.task_template_group_id
4272: and a.task_template_id = g.task_template_id
4273: and a.product_id = p_inventory_item_id

Line 4334: jtf_task_templates_vl g

4330: qp_price_list_lines_v c,
4331: mtl_system_items_kfv d,
4332: csd_repair_types_sar e,
4333: cs_txn_billing_types f,
4334: jtf_task_templates_vl g
4335: WHERE
4336: SetLinkRO.other_id = p_repair_line_id
4337: and SetLinkRO.object_code = 'DR'
4338: and SetLinkRO.link_type = 'S'

Line 4395: JTF_TASK_TEMPLATES_VL g

4391: -- QP_PRICE_LIST_LINES_V c,
4392: MTL_SYSTEM_ITEMS_KFV d,
4393: CSD_REPAIR_TYPES_SAR e,
4394: CS_TXN_BILLING_TYPES f,
4395: JTF_TASK_TEMPLATES_VL g
4396: WHERE ROSC.repair_line_id = p_repair_line_id
4397: AND ROSC.applicable_flag = 'Y'
4398: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4399: AND ROSC.applied_to_est_flag = 'N'

Line 4450: JTF_TASK_TEMPLATES_VL g

4446: -- QP_PRICE_LIST_LINES_V c,
4447: MTL_SYSTEM_ITEMS_KFV d,
4448: CSD_REPAIR_TYPES_SAR e,
4449: CS_TXN_BILLING_TYPES f,
4450: JTF_TASK_TEMPLATES_VL g
4451: WHERE ROSC.repair_line_id = p_repair_line_id
4452: AND ROSC.applicable_flag = 'Y'
4453: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
4454: AND ROSC.applied_to_est_flag = 'N'

Line 4506: jtf_task_templates_vl g

4502: -- qp_price_list_lines_v c,
4503: mtl_system_items_kfv d,
4504: CSD_REPAIR_TYPES_SAR e,
4505: cs_txn_billing_types f,
4506: jtf_task_templates_vl g
4507: WHERE g.task_group_id =
4508: JtfTaskTempGroupEO.task_template_group_id
4509: AND a.task_template_id = g.task_template_id
4510: AND a.product_id = p_inventory_item_id

Line 4570: jtf_task_templates_vl g

4566: -- qp_price_list_lines_v c,
4567: mtl_system_items_kfv d,
4568: CSD_REPAIR_TYPES_SAR e,
4569: cs_txn_billing_types f,
4570: jtf_task_templates_vl g
4571: WHERE SetLinkRO.other_id = p_repair_line_id
4572: AND SetLinkRO.object_code = 'DR'
4573: AND SetLinkRO.link_type = 'S'
4574: AND SetLinkTG.set_id = SetLinkRO.set_id

Line 4638: jtf_task_templates_vl y,

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