DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_OBJECT_GENEALOGY

Line 2358: FROM mtl_object_genealogy mog,

2354: CURSOR c_lotComp IS
2355:
2356: SELECT mtln.lot_number lot,
2357: mtln.primary_quantity * -1 lot_qty
2358: FROM mtl_object_genealogy mog,
2359: mtl_material_transactions mmt,
2360: mtl_transaction_lot_numbers mtln,
2361: mtl_lot_numbers mln
2362: WHERE mog.object_id = mln.gen_object_id

Line 2482: FROM mtl_object_genealogy mog,

2478:
2479: CURSOR c_revisionComp IS
2480:
2481: SELECT mmt.revision revision
2482: FROM mtl_object_genealogy mog,
2483: mtl_material_transactions mmt,
2484: mtl_transaction_lot_numbers mtln,
2485: mtl_lot_numbers mln
2486: WHERE mog.object_id = mln.gen_object_id