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 CS_TXN_BILLING_TYPES

Line 4121: CS_TXN_BILLING_TYPES f,

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
4124: and ROSC.applicable_flag = 'Y'
4125: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 4175: CS_TXN_BILLING_TYPES f,

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
4178: and ROSC.applicable_flag = 'Y'
4179: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 4234: cs_txn_billing_types f,

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
4237: g.task_group_id = JtfTaskTempGroupEO.task_template_group_id
4238: and a.task_template_id = g.task_template_id

Line 4299: cs_txn_billing_types f,

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
4302: SetLinkRO.other_id = p_repair_line_id
4303: and SetLinkRO.object_code = 'DR'

Line 4360: CS_TXN_BILLING_TYPES f,

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
4363: AND ROSC.applicable_flag = 'Y'
4364: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 4415: CS_TXN_BILLING_TYPES f,

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
4418: AND ROSC.applicable_flag = 'Y'
4419: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 4471: cs_txn_billing_types f,

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 =
4474: JtfTaskTempGroupEO.task_template_group_id
4475: AND a.task_template_id = g.task_template_id

Line 4535: cs_txn_billing_types f,

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
4538: AND SetLinkRO.object_code = 'DR'
4539: AND SetLinkRO.link_type = 'S'

Line 5369: CS_TXN_BILLING_TYPES SAR

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

Line 5421: CS_TXN_BILLING_TYPES SAR,

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
5424: and ROSC.applicable_flag = 'Y'
5425: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 5472: CS_TXN_BILLING_TYPES SAR

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'
5475: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
5476: AND ROSC.applied_to_est_flag = 'N'

Line 5523: CS_TXN_BILLING_TYPES SAR,

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
5526: AND ROSC.applicable_flag = 'Y'
5527: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.

Line 6035: cs_txn_billing_types cs

6031: cursor count_csi_txn_subtypes (p_txn_billing_type_id NUMBER) is
6032: -- number of txn subtypes for a given txn billing type
6033: SELECT count(*)
6034: FROM csi_txn_sub_types ib,
6035: cs_txn_billing_types cs
6036: WHERE ib.cs_transaction_type_id = cs.transaction_type_id
6037: and cs.txn_billing_type_id = p_txn_billing_type_id;
6038: */
6039:

Line 6042: FROM cs_txn_billing_types cs

6038: */
6039:
6040: CURSOR c_transaction_type(p_txn_billing_type_id NUMBER) IS
6041: SELECT cs.transaction_type_id
6042: FROM cs_txn_billing_types cs
6043: WHERE cs.txn_billing_type_id = p_txn_billing_type_id;
6044:
6045: BEGIN
6046: -- Standard Start of API savepoint