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_ACTUAL_PROCESS_PVT dependencies on CS_TXN_BILLING_TYPES

Line 104: FROM CS_TXN_BILLING_TYPES TBT,

100: AND MSID.organization_id = p_depot_organization
101: AND MSID.material_billable_flag IS NOT NULL
102: AND NOT EXISTS
103: (SELECT 'x'
104: FROM CS_TXN_BILLING_TYPES TBT,
105: CSD_REPAIR_TYPES_SAR SAR
106: WHERE TBT.billing_type = MSID.material_billable_flag
107: AND SAR.txn_billing_type_id = TBT.txn_billing_type_id
108: AND SAR.repair_type_id = p_repair_type_id

Line 332: FROM CS_TXN_BILLING_TYPES TBT,

328: AND MSID.organization_id = p_depot_organization
329: AND MSID.material_billable_flag IS NOT NULL
330: AND NOT EXISTS
331: (SELECT 'x'
332: FROM CS_TXN_BILLING_TYPES TBT,
333: CSD_REPAIR_TYPES_SAR SAR
334: WHERE TBT.billing_type = MSID.material_billable_flag
335: AND SAR.txn_billing_type_id = TBT.txn_billing_type_id
336: AND SAR.repair_type_id = p_repair_type_id

Line 1298: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT

1294: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
1295: G_ACTUAL_SOURCE_CODE_WIP ACTUAL_SOURCE_CODE,
1296: l_wip_entity_id ACTUAL_SOURCE_ID
1297: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,
1298: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT
1299: WHERE MMT.transaction_source_id = l_wip_entity_id
1300: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
1301: AND MMT.transaction_type_id IN( G_MTL_TXN_TYPE_COMP_ISSUE,
1302: G_MTL_TXN_TYPE_COMP_RETURN )

Line 1331: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT

1327: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
1328: G_ACTUAL_SOURCE_CODE_WIP ACTUAL_SOURCE_CODE,
1329: l_wip_entity_id ACTUAL_SOURCE_ID
1330: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,
1331: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT
1332: WHERE MMT.transaction_source_id = l_wip_entity_id
1333: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
1334: AND MMT.transaction_type_id IN( G_MTL_TXN_TYPE_COMP_ISSUE,
1335: G_MTL_TXN_TYPE_COMP_RETURN )

Line 1380: CS_TXN_BILLING_TYPES TXBT

1376: l_wip_entity_id ACTUAL_SOURCE_ID,
1377: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
1378: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
1379: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
1380: CS_TXN_BILLING_TYPES TXBT
1381: WHERE WTXN.wip_entity_id = l_wip_entity_id
1382: AND WTXN.transaction_type IN( 1, 2, 3 )
1383: AND RES.resource_id = WTXN.resource_id
1384: AND MSI.inventory_item_id = RES.billable_item_id