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 4155: CS_TXN_BILLING_TYPES f,

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

Line 4209: CS_TXN_BILLING_TYPES f,

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

Line 4268: cs_txn_billing_types f,

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
4272: and a.task_template_id = g.task_template_id

Line 4333: cs_txn_billing_types f,

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
4337: and SetLinkRO.object_code = 'DR'

Line 4394: CS_TXN_BILLING_TYPES f,

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

Line 4449: CS_TXN_BILLING_TYPES f,

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

Line 4505: cs_txn_billing_types f,

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
4509: AND a.task_template_id = g.task_template_id

Line 4569: cs_txn_billing_types f,

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'
4573: AND SetLinkRO.link_type = 'S'

Line 5403: CS_TXN_BILLING_TYPES SAR

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.
5407: and ROSC.applied_to_est_flag = 'N'

Line 5455: CS_TXN_BILLING_TYPES SAR,

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

Line 5506: CS_TXN_BILLING_TYPES SAR

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.
5510: AND ROSC.applied_to_est_flag = 'N'

Line 5557: CS_TXN_BILLING_TYPES SAR,

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

Line 6069: cs_txn_billing_types cs

6065: cursor count_csi_txn_subtypes (p_txn_billing_type_id NUMBER) is
6066: -- number of txn subtypes for a given txn billing type
6067: SELECT count(*)
6068: FROM csi_txn_sub_types ib,
6069: cs_txn_billing_types cs
6070: WHERE ib.cs_transaction_type_id = cs.transaction_type_id
6071: and cs.txn_billing_type_id = p_txn_billing_type_id;
6072: */
6073:

Line 6076: FROM cs_txn_billing_types cs

6072: */
6073:
6074: CURSOR c_transaction_type(p_txn_billing_type_id NUMBER) IS
6075: SELECT cs.transaction_type_id
6076: FROM cs_txn_billing_types cs
6077: WHERE cs.txn_billing_type_id = p_txn_billing_type_id;
6078:
6079: BEGIN
6080: -- Standard Start of API savepoint

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 7748: CS_TXN_BILLING_TYPES TXBT

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
7752: AND MSI.inventory_item_id = RES.billable_item_id

Line 7795: CS_TXN_BILLING_TYPES TXBT

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
7799: AND MSI.organization_id = p_organization_id