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 MTL_SYSTEM_ITEMS_KFV

Line 75: MTL_SYSTEM_ITEMS_KFV MSIW,-- For WIP organization

71: MSID.inventory_item_id DEPOT_ITEM_ID,
72: MSID.material_billable_flag BILLING_TYPE
73: FROM WIP_TRANSACTIONS WTXN,
74: BOM_RESOURCES RES,
75: MTL_SYSTEM_ITEMS_KFV MSIW,-- For WIP organization
76: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
77: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization
78: WHERE WTXN.wip_entity_id = p_wip_entity_id
79: AND RES.resource_id = WTXN.resource_id

Line 76: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization

72: MSID.material_billable_flag BILLING_TYPE
73: FROM WIP_TRANSACTIONS WTXN,
74: BOM_RESOURCES RES,
75: MTL_SYSTEM_ITEMS_KFV MSIW,-- For WIP organization
76: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
77: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization
78: WHERE WTXN.wip_entity_id = p_wip_entity_id
79: AND RES.resource_id = WTXN.resource_id
80: AND MSIW.inventory_item_id = RES.billable_item_id

Line 96: MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization

92: SUM( NVL( WTXN.primary_quantity, 0 )) QUANTITY,
93: MSID.concatenated_segments DEPOT_ITEM_NAME
94: FROM WIP_TRANSACTIONS WTXN,
95: BOM_RESOURCES RES,
96: MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
97: WHERE WTXN.wip_entity_id = p_wip_entity_id
98: AND RES.resource_id = WTXN.resource_id
99: AND MSID.inventory_item_id = RES.billable_item_id
100: AND MSID.organization_id = p_depot_organization

Line 294: MTL_SYSTEM_ITEMS_KFV MSIW, -- For WIP organization

290: , G_MTL_TXN_TYPE_COMP_RETURN,( -1 * ABS( mmt.primary_quantity )))) Quantity,
291: MSID.inventory_item_id DEPOT_ITEM_ID,
292: MSID.material_billable_flag BILLING_TYPE
293: FROM MTL_MATERIAL_TRANSACTIONS MMT,
294: MTL_SYSTEM_ITEMS_KFV MSIW, -- For WIP organization
295: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization
296: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
297: WHERE MMT.transaction_source_id = p_wip_entity_id
298: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP

Line 296: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization

292: MSID.material_billable_flag BILLING_TYPE
293: FROM MTL_MATERIAL_TRANSACTIONS MMT,
294: MTL_SYSTEM_ITEMS_KFV MSIW, -- For WIP organization
295: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization
296: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
297: WHERE MMT.transaction_source_id = p_wip_entity_id
298: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
299: AND MMT.transaction_type_id IN( G_MTL_TXN_TYPE_COMP_ISSUE,
300: G_MTL_TXN_TYPE_COMP_RETURN )

Line 321: MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization

317: SUM( DECODE( MMT.transaction_type_id
318: , G_MTL_TXN_TYPE_COMP_ISSUE, ABS( mmt.primary_quantity )
319: , G_MTL_TXN_TYPE_COMP_RETURN,( -1 * ABS( mmt.primary_quantity )))) Quantity
320: FROM MTL_MATERIAL_TRANSACTIONS MMT,
321: MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
322: WHERE MMT.transaction_source_id = p_wip_entity_id
323: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
324: AND MMT.transaction_type_id IN( G_MTL_TXN_TYPE_COMP_ISSUE,
325: G_MTL_TXN_TYPE_COMP_RETURN )

Line 1275: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,

1271: MSI.comms_nl_trackable_flag IB_TRACKABLE_FLAG,
1272: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
1273: G_ACTUAL_SOURCE_CODE_WIP ACTUAL_SOURCE_CODE,
1274: l_wip_entity_id ACTUAL_SOURCE_ID
1275: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_KFV MSI,
1276: CSD_REPAIR_TYPES_SAR RTYP, CS_TXN_BILLING_TYPES TXBT
1277: WHERE MMT.transaction_source_id = l_wip_entity_id
1278: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
1279: AND MMT.transaction_type_id IN( G_MTL_TXN_TYPE_COMP_ISSUE,

Line 1322: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,

1318: G_ACTUAL_SOURCE_CODE_WIP ACTUAL_SOURCE_CODE,
1319: l_wip_entity_id ACTUAL_SOURCE_ID,
1320: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
1321: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
1322: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
1323: CS_TXN_BILLING_TYPES TXBT
1324: WHERE WTXN.wip_entity_id = l_wip_entity_id
1325: AND WTXN.transaction_type IN( 1, 2, 3 )
1326: AND RES.resource_id = WTXN.resource_id