DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_OBJECT_GENEALOGY

Line 2287: FROM mtl_object_genealogy mog,

2283: CURSOR c_lotComp IS
2284:
2285: SELECT mtln.lot_number lot,
2286: mtln.primary_quantity * -1 lot_qty
2287: FROM mtl_object_genealogy mog,
2288: mtl_material_transactions mmt,
2289: mtl_transaction_lot_numbers mtln,
2290: mtl_lot_numbers mln
2291: WHERE mog.object_id = mln.gen_object_id

Line 2411: FROM mtl_object_genealogy mog,

2407:
2408: CURSOR c_revisionComp IS
2409:
2410: SELECT mmt.revision revision
2411: FROM mtl_object_genealogy mog,
2412: mtl_material_transactions mmt,
2413: mtl_transaction_lot_numbers mtln,
2414: mtl_lot_numbers mln
2415: WHERE mog.object_id = mln.gen_object_id