APPS.GMF_PERIODCLOSE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 337: mtl_material_transactions mmt

333: SUM(mtln.primary_quantity) pri_qty,
334: SUM(NVL(mtln.secondary_transaction_quantity,0)) sec_qty
335: FROM
336: mtl_transaction_lot_numbers mtln,
337: mtl_material_transactions mmt
338: WHERE
339: mmt.transaction_id = mtln.transaction_id AND
340: mmt.organization_id = p_organization_id AND
341: mmt.transaction_date > p_rollback_to_date AND

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

352: mmt.inventory_item_id,
353: mmt.locator_id,
354: mtln.lot_number
355: UNION ALL
356: SELECT /*+ INDEX(mmt mtl_material_transactions_n5) */ /* non lot controlled items */
357: mmt.organization_id,
358: mmt.cost_group_id,
359: mmt.subinventory_code,
360: mmt.inventory_item_id,

Line 367: mtl_material_transactions mmt

363: SUM(mmt.primary_quantity) pri_qty,
364: SUM(NVL(mmt.secondary_transaction_quantity,0)) sec_qty
365: FROM
366: mtl_system_items_b msi,
367: mtl_material_transactions mmt
368: WHERE
369: mmt.inventory_item_id = msi.inventory_item_id AND
370: mmt.organization_id = msi.organization_id AND
371: msi.lot_control_code = 1 AND /* no lot control */