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 3784: FROM mtl_system_items_kfv

3780: x_warning_flag := Fnd_Api.G_TRUE;
3781: BEGIN
3782: SELECT concatenated_segments
3783: INTO l_item_name
3784: FROM mtl_system_items_kfv
3785: WHERE inventory_item_id = l_est_lines_tbl(i)
3786: .inventory_item_id
3787: AND organization_id = l_est_lines_tbl(i)
3788: .organization_id;

Line 4153: MTL_SYSTEM_ITEMS_KFV d,

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,
4155: CS_TXN_BILLING_TYPES f,
4156: JTF_TASK_TEMPLATES_VL g
4157: WHERE ROSC.repair_line_id = p_repair_line_id

Line 4207: MTL_SYSTEM_ITEMS_KFV d,

4203: CSD_SERVICE_CODES_VL SC,
4204: CSD_SC_WORK_ENTITIES WRK,
4205: JTF_TASK_TEMPLATES_B b,
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

Line 4266: mtl_system_items_kfv d,

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,
4268: cs_txn_billing_types f,
4269: jtf_task_templates_vl g
4270: WHERE

Line 4331: mtl_system_items_kfv d,

4327: cs_kb_sets_vl KBSets,
4328: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4329: jtf_task_templates_b b,
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

Line 4392: MTL_SYSTEM_ITEMS_KFV d,

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,
4394: CS_TXN_BILLING_TYPES f,
4395: JTF_TASK_TEMPLATES_VL g
4396: WHERE ROSC.repair_line_id = p_repair_line_id

Line 4447: MTL_SYSTEM_ITEMS_KFV d,

4443: CSD_SERVICE_CODES_VL SC,
4444: CSD_SC_WORK_ENTITIES WRK,
4445: JTF_TASK_TEMPLATES_B b,
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

Line 4503: mtl_system_items_kfv d,

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,
4505: cs_txn_billing_types f,
4506: jtf_task_templates_vl g
4507: WHERE g.task_group_id =

Line 4567: mtl_system_items_kfv d,

4563: cs_kb_sets_vl KBSets,
4564: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4565: jtf_task_templates_b b,
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

Line 5401: MTL_SYSTEM_ITEMS_KFV MTL,

5397: CSD_SERVICE_CODES_VL SC,
5398: CSD_SC_WORK_ENTITIES WRK,
5399: BOM_INVENTORY_COMPONENTS_V BOM,
5400: QP_PRICE_LIST_LINES_V PRICE,
5401: MTL_SYSTEM_ITEMS_KFV MTL,
5402: CSD_REPAIR_TYPES_SAR RTSAR,
5403: CS_TXN_BILLING_TYPES SAR
5404: WHERE ROSC.repair_line_id = p_repair_line_id
5405: and ROSC.applicable_flag = 'Y'

Line 5453: MTL_SYSTEM_ITEMS_KFV MTL,

5449: CSD_SERVICE_CODES_VL SC,
5450: BOM_OPERATION_SEQUENCES OPSEQ,
5451: BOM_OPERATION_RESOURCES OPRES,
5452: QP_PRICE_LIST_LINES_V PRICE,
5453: MTL_SYSTEM_ITEMS_KFV MTL,
5454: CSD_REPAIR_TYPES_SAR RTSAR,
5455: CS_TXN_BILLING_TYPES SAR,
5456: BOM_RESOURCES RES
5457: WHERE ROSC.repair_line_id = p_repair_line_id

Line 5504: MTL_SYSTEM_ITEMS_KFV MTL,

5500: CSD_SERVICE_CODES_VL SC,
5501: CSD_SC_WORK_ENTITIES WRK,
5502: BOM_INVENTORY_COMPONENTS_V BOM,
5503: -- QP_PRICE_LIST_LINES_V PRICE,
5504: MTL_SYSTEM_ITEMS_KFV MTL,
5505: CSD_REPAIR_TYPES_SAR RTSAR,
5506: CS_TXN_BILLING_TYPES SAR
5507: WHERE ROSC.repair_line_id = p_repair_line_id
5508: AND ROSC.applicable_flag = 'Y'

Line 5555: MTL_SYSTEM_ITEMS_KFV MTL,

5551: CSD_SERVICE_CODES_VL SC,
5552: BOM_OPERATION_SEQUENCES OPSEQ,
5553: BOM_OPERATION_RESOURCES OPRES,
5554: -- QP_PRICE_LIST_LINES_V PRICE,
5555: MTL_SYSTEM_ITEMS_KFV MTL,
5556: CSD_REPAIR_TYPES_SAR RTSAR,
5557: CS_TXN_BILLING_TYPES SAR,
5558: BOM_RESOURCES RES
5559: WHERE ROSC.repair_line_id = p_repair_line_id

Line 7642: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,

7638: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
7639: G_ESTIMATE_SOURCE_CODE_WIP ESTIMATE_SOURCE_CODE,
7640: l_wip_entity_id ESTIMATE_SOURCE_ID,
7641: mmt.operation_seq_num OPERATION_SEQ_NUM
7642: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,
7643: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT
7644: WHERE MMT.transaction_source_id = l_wip_entity_id
7645: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
7646: AND MMT.transaction_type_id IN( G_MTL_TXN_TYPE_COMP_ISSUE,

Line 7678: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,

7674: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
7675: G_ESTIMATE_SOURCE_CODE_WIP ESTIMATE_SOURCE_CODE,
7676: l_wip_entity_id ESTIMATE_SOURCE_ID,
7677: mmt.operation_seq_num OPERATION_SEQ_NUM
7678: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,
7679: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT
7680: WHERE MMT.transaction_source_id = l_wip_entity_id
7681: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
7682: AND MMT.inventory_item_id <> l_inventory_item_id

Line 7710: FROM WIP_REQUIREMENT_OPERATIONS wro, MTL_SYSTEM_ITEMS_KFV MSI,

7706: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
7707: G_ESTIMATE_SOURCE_CODE_WIP ESTIMATE_SOURCE_CODE,
7708: l_wip_entity_id ESTIMATE_SOURCE_ID,
7709: wro.operation_seq_num OPERATION_SEQ_NUM
7710: FROM WIP_REQUIREMENT_OPERATIONS wro, MTL_SYSTEM_ITEMS_KFV MSI,
7711: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT
7712: WHERE wro.wip_entity_id = l_wip_entity_id
7713: AND wro.inventory_item_id <> l_inventory_item_id
7714: AND MSI.inventory_item_id = wro.inventory_item_id

Line 7747: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,

7743: l_wip_entity_id ESTIMATE_SOURCE_ID,
7744: wtxn.operation_seq_num OPERATION_SEQ_NUM,
7745: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
7746: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
7747: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
7748: CS_TXN_BILLING_TYPES TXBT
7749: WHERE WTXN.wip_entity_id = l_wip_entity_id
7750: AND WTXN.transaction_type IN( 1, 2, 3 )
7751: AND RES.resource_id = WTXN.resource_id

Line 7794: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,

7790: WOR.operation_seq_num OPERATION_SEQ_NUM,
7791: RES.resource_id RESOURCE_ID
7792: FROM WIP_OPERATION_RESOURCES WOR, wip_operations wo,
7793: CSD_WIP_TRANSACTION_DETAILS WTD, BOM_RESOURCES RES,
7794: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
7795: CS_TXN_BILLING_TYPES TXBT
7796: WHERE WOR.wip_entity_id = l_wip_entity_id
7797: AND RES.resource_id = WOR.resource_id
7798: AND MSI.inventory_item_id = RES.billable_item_id