DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 2950: mtl_transaction_lot_numbers l2

2946: l2.lot_number lot_num,
2947: SUM(l2.primary_quantity) txn_qty,
2948: SUM(NVL(l2.secondary_transaction_quantity,0)) txn_sec_qty
2949: FROM mtl_material_transactions m2,
2950: mtl_transaction_lot_numbers l2
2951: WHERE l2.transaction_id = m2.transaction_id
2952: AND l2.lot_number LIKE (p_lot_number)
2953: AND m2.organization_id = p_organization_id
2954: AND m2.transaction_source_id = p_batch_id