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 CSD_REPAIR_TYPES_SAR

Line 4154: CSD_REPAIR_TYPES_SAR e,

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
4158: and ROSC.applicable_flag = 'Y'

Line 4208: CSD_REPAIR_TYPES_SAR e,

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
4212: and ROSC.applicable_flag = 'Y'

Line 4267: csd_repair_types_sar e,

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
4271: g.task_group_id = JtfTaskTempGroupEO.task_template_group_id

Line 4332: csd_repair_types_sar e,

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
4336: SetLinkRO.other_id = p_repair_line_id

Line 4393: CSD_REPAIR_TYPES_SAR e,

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
4397: AND ROSC.applicable_flag = 'Y'

Line 4448: CSD_REPAIR_TYPES_SAR e,

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
4452: AND ROSC.applicable_flag = 'Y'

Line 4504: CSD_REPAIR_TYPES_SAR e,

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 =
4508: JtfTaskTempGroupEO.task_template_group_id

Line 4568: CSD_REPAIR_TYPES_SAR e,

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
4572: AND SetLinkRO.object_code = 'DR'

Line 5402: CSD_REPAIR_TYPES_SAR RTSAR,

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'
5406: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 5454: CSD_REPAIR_TYPES_SAR RTSAR,

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
5458: and ROSC.applicable_flag = 'Y'

Line 5505: CSD_REPAIR_TYPES_SAR RTSAR,

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'
5509: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 5556: CSD_REPAIR_TYPES_SAR RTSAR,

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
5560: AND ROSC.applicable_flag = 'Y'

Line 7643: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT

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,
7647: G_MTL_TXN_TYPE_COMP_RETURN )

Line 7679: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT

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
7683: AND MSI.inventory_item_id = MMT.inventory_item_id

Line 7711: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT

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
7715: AND MSI.organization_id = p_organization_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