DBA Data[Home] [Help]

APPS.GMF_PERIODCLOSE_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 355: MTL_SECONDARY_INVENTORIES sinv /*B8404849*/

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
359: mmt.transaction_date > p_rollback_to_date AND

Line 391: MTL_SECONDARY_INVENTORIES sinv /*B8404849*/

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
395: msi.lot_control_code = 1 AND /* no lot control */