APPS.CSTACPCS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 42: MTL_MATERIAL_TRANSACTIONS MMT,

38: MMT.INVENTORY_ITEM_ID,
39: MMT.SUBINVENTORY_CODE
40: FROM
41: MTL_PER_CLOSE_DTLS MPSD ,
42: MTL_MATERIAL_TRANSACTIONS MMT,
43: ORG_ACCT_PERIODS OAP
44: WHERE
45: MPSD.ACCT_PERIOD_ID = C_ACCT_PERIOD_ID AND
46: MPSD.ORGANIZATION_ID = C_ORG_ID AND

Line 89: MTL_MATERIAL_TRANSACTIONS MMT,

85: IS
86: SELECT MCACD.TRANSACTION_ID
87: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,
88: CST_QUANTITY_LAYERS CQL,
89: MTL_MATERIAL_TRANSACTIONS MMT,
90: MTL_SECONDARY_INVENTORIES MSI
91: WHERE MCACD.INVENTORY_ITEM_ID = c_item_id
92: AND MCACD.ORGANIZATION_ID = c_org_id
93: AND MCACD.LAYER_ID = CQL.LAYER_ID

Line 253: FROM MTL_MATERIAL_TRANSACTIONS MMT

249: SUP.FROM_ORGANIZATION_ID = I_ORG_ID) AND
250: SUP.SHIPMENT_HEADER_ID + 0 = RSH.SHIPMENT_HEADER_ID AND
251: EXISTS
252: (SELECT 'X'
253: FROM MTL_MATERIAL_TRANSACTIONS MMT
254: WHERE
255: MMT.INVENTORY_ITEM_ID = SUP.ITEM_ID AND
256: ((SUP.FROM_ORGANIZATION_ID = MMT.ORGANIZATION_ID AND
257: SUP.TO_ORGANIZATION_ID = MMT.TRANSFER_ORGANIZATION_ID

Line 338: MTL_MATERIAL_TRANSACTIONS MMT,

334: i_prog_id,
335: i_prog_appl_id,
336: i_user_id
337: FROM
338: MTL_MATERIAL_TRANSACTIONS MMT,
339: MTL_SECONDARY_INVENTORIES SUB
340: WHERE
341: MMT.ORGANIZATION_ID = I_ORG_ID AND
342: MMT.ORGANIZATION_ID = nvl(MMT.OWNING_ORGANIZATION_ID, MMT.ORGANIZATION_ID) AND

Line 492: MTL_MATERIAL_TRANSACTIONS MMT

488: RSH.SHIPMENT_HEADER_ID = SUP.SHIPMENT_HEADER_ID AND
489: EXISTS
490: (SELECT 'X'
491: FROM
492: MTL_MATERIAL_TRANSACTIONS MMT
493: WHERE
494: SUP.ITEM_ID = MMT.INVENTORY_ITEM_ID AND
495: ( --Added for Bug #1478959 in 11.0 .... Porting the changes to 11.5 Bug 1521581*/
496: (SUP.FROM_ORGANIZATION_ID = MMT.ORGANIZATION_ID AND