DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 2923: mtl_transaction_lot_numbers l2

2919: l2.lot_number lot_num,
2920: SUM(l2.primary_quantity) txn_qty,
2921: SUM(NVL(l2.secondary_transaction_quantity,0)) txn_sec_qty
2922: FROM mtl_material_transactions m2,
2923: mtl_transaction_lot_numbers l2
2924: WHERE l2.transaction_id = m2.transaction_id
2925: AND l2.lot_number LIKE (p_lot_number)
2926: AND m2.organization_id = p_organization_id
2927: AND m2.transaction_source_id = p_batch_id