DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 159: MTL_MATERIAL_TRANSACTIONS M,

155: mp.organization_code,
156: M.SUBINVENTORY_code,
157: M.LOCATOR_ID
158: FROM MTL_SYSTEM_ITEMS_B_KFV B,
159: MTL_MATERIAL_TRANSACTIONS M,
160: MTL_TRANSACTION_TYPES T,
161: mtl_parameters mp
162: WHERE M.transaction_id = l_event_key
163: AND M.organization_id = B.organization_id

Line 173: MTL_MATERIAL_TRANSACTIONS M,

169: CURSOR inv_lot IS
170: SELECT c.PARENT_LOT_NUMBER,
171: c.LOT_NUMBER
172: FROM MTL_LOT_NUMBERS C,
173: MTL_MATERIAL_TRANSACTIONS M,
174: MTL_TRANSACTION_LOT_NUMBERS L
175: WHERE M.transaction_id = l_event_key
176: AND M.inventory_item_id = C.inventory_item_id
177: AND M.organization_id = C.organization_id