APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 293: FROM MTL_MATERIAL_TRANSACTIONS MMT,

289: , G_MTL_TXN_TYPE_COMP_ISSUE, ABS( mmt.primary_quantity )
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

Line 320: FROM MTL_MATERIAL_TRANSACTIONS MMT,

316: MSID.concatenated_segments DEPOT_ITEM_NAME,
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,

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,