APPS.GMF_PERIODCLOSE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 354: mtl_material_transactions mmt,

350: SUM(mtln.primary_quantity) pri_qty,
351: SUM(NVL(mtln.secondary_transaction_quantity,0)) sec_qty
352: FROM
353: mtl_transaction_lot_numbers mtln,
354: mtl_material_transactions mmt,
355: MTL_SECONDARY_INVENTORIES sinv /*B8404849*/
356: WHERE
357: mmt.transaction_id = mtln.transaction_id AND
358: mmt.organization_id = p_organization_id AND

Line 379: SELECT /*+ INDEX(mmt mtl_material_transactions_n5) */ /* non lot controlled items */

375: mmt.inventory_item_id,
376: mmt.locator_id,
377: mtln.lot_number
378: UNION ALL
379: SELECT /*+ INDEX(mmt mtl_material_transactions_n5) */ /* non lot controlled items */
380: mmt.organization_id,
381: mmt.cost_group_id,
382: mmt.subinventory_code,
383: mmt.inventory_item_id,

Line 390: mtl_material_transactions mmt,

386: SUM(mmt.primary_quantity) pri_qty,
387: SUM(NVL(mmt.secondary_transaction_quantity,0)) sec_qty
388: FROM
389: mtl_system_items_b msi,
390: mtl_material_transactions mmt,
391: MTL_SECONDARY_INVENTORIES sinv /*B8404849*/
392: WHERE
393: mmt.inventory_item_id = msi.inventory_item_id AND
394: mmt.organization_id = msi.organization_id AND