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 MTL_SYSTEM_ITEMS_KFV

Line 3750: FROM mtl_system_items_kfv

3746: x_warning_flag := Fnd_Api.G_TRUE;
3747: BEGIN
3748: SELECT concatenated_segments
3749: INTO l_item_name
3750: FROM mtl_system_items_kfv
3751: WHERE inventory_item_id = l_est_lines_tbl(i)
3752: .inventory_item_id
3753: AND organization_id = l_est_lines_tbl(i)
3754: .organization_id;

Line 4119: MTL_SYSTEM_ITEMS_KFV d,

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,
4121: CS_TXN_BILLING_TYPES f,
4122: JTF_TASK_TEMPLATES_VL g
4123: WHERE ROSC.repair_line_id = p_repair_line_id

Line 4173: MTL_SYSTEM_ITEMS_KFV d,

4169: CSD_SERVICE_CODES_VL SC,
4170: CSD_SC_WORK_ENTITIES WRK,
4171: JTF_TASK_TEMPLATES_B b,
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

Line 4232: mtl_system_items_kfv d,

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,
4234: cs_txn_billing_types f,
4235: jtf_task_templates_vl g
4236: WHERE

Line 4297: mtl_system_items_kfv d,

4293: cs_kb_sets_vl KBSets,
4294: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4295: jtf_task_templates_b b,
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

Line 4358: MTL_SYSTEM_ITEMS_KFV d,

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,
4360: CS_TXN_BILLING_TYPES f,
4361: JTF_TASK_TEMPLATES_VL g
4362: WHERE ROSC.repair_line_id = p_repair_line_id

Line 4413: MTL_SYSTEM_ITEMS_KFV d,

4409: CSD_SERVICE_CODES_VL SC,
4410: CSD_SC_WORK_ENTITIES WRK,
4411: JTF_TASK_TEMPLATES_B b,
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

Line 4469: mtl_system_items_kfv d,

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,
4471: cs_txn_billing_types f,
4472: jtf_task_templates_vl g
4473: WHERE g.task_group_id =

Line 4533: mtl_system_items_kfv d,

4529: cs_kb_sets_vl KBSets,
4530: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4531: jtf_task_templates_b b,
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

Line 5367: MTL_SYSTEM_ITEMS_KFV MTL,

5363: CSD_SERVICE_CODES_VL SC,
5364: CSD_SC_WORK_ENTITIES WRK,
5365: BOM_INVENTORY_COMPONENTS_V BOM,
5366: QP_PRICE_LIST_LINES_V PRICE,
5367: MTL_SYSTEM_ITEMS_KFV MTL,
5368: CSD_REPAIR_TYPES_SAR RTSAR,
5369: CS_TXN_BILLING_TYPES SAR
5370: WHERE ROSC.repair_line_id = p_repair_line_id
5371: and ROSC.applicable_flag = 'Y'

Line 5419: MTL_SYSTEM_ITEMS_KFV MTL,

5415: CSD_SERVICE_CODES_VL SC,
5416: BOM_OPERATION_SEQUENCES OPSEQ,
5417: BOM_OPERATION_RESOURCES OPRES,
5418: QP_PRICE_LIST_LINES_V PRICE,
5419: MTL_SYSTEM_ITEMS_KFV MTL,
5420: CSD_REPAIR_TYPES_SAR RTSAR,
5421: CS_TXN_BILLING_TYPES SAR,
5422: BOM_RESOURCES RES
5423: WHERE ROSC.repair_line_id = p_repair_line_id

Line 5470: MTL_SYSTEM_ITEMS_KFV MTL,

5466: CSD_SERVICE_CODES_VL SC,
5467: CSD_SC_WORK_ENTITIES WRK,
5468: BOM_INVENTORY_COMPONENTS_V BOM,
5469: -- QP_PRICE_LIST_LINES_V PRICE,
5470: MTL_SYSTEM_ITEMS_KFV MTL,
5471: CSD_REPAIR_TYPES_SAR RTSAR,
5472: CS_TXN_BILLING_TYPES SAR
5473: WHERE ROSC.repair_line_id = p_repair_line_id
5474: AND ROSC.applicable_flag = 'Y'

Line 5521: MTL_SYSTEM_ITEMS_KFV MTL,

5517: CSD_SERVICE_CODES_VL SC,
5518: BOM_OPERATION_SEQUENCES OPSEQ,
5519: BOM_OPERATION_RESOURCES OPRES,
5520: -- QP_PRICE_LIST_LINES_V PRICE,
5521: MTL_SYSTEM_ITEMS_KFV MTL,
5522: CSD_REPAIR_TYPES_SAR RTSAR,
5523: CS_TXN_BILLING_TYPES SAR,
5524: BOM_RESOURCES RES
5525: WHERE ROSC.repair_line_id = p_repair_line_id