APPS.GME_MOBILE_TXN dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 707: mtl_transaction_lot_numbers l

703: SELECT m.revision,lot_number,
704: ABS(SUM (NVL(l.primary_quantity,0))),
705: ABS(SUM (NVL(l.secondary_transaction_quantity,0)))
706: FROM mtl_material_transactions m,
707: mtl_transaction_lot_numbers l
708: WHERE l.transaction_id = m.transaction_id
709: AND lot_number = NVL(p_lot_number, l.lot_number)
710: AND m.organization_id = p_org_id
711: AND m.transaction_source_id = p_batch_id

Line 895: FROM mtl_transaction_lot_numbers

891: lot_number,
892: transaction_quantity *(-1),
893: primary_quantity *(-1),
894: secondary_transaction_quantity *(-1)
895: FROM mtl_transaction_lot_numbers
896: WHERE transaction_id = p_transaction_id AND
897: lot_number = NVL(p_lot_number, lot_number);
898:
899: EXCEPTION

Line 3358: mtl_transaction_lot_numbers l,

3354: lc.concatenated_segments,
3355: TO_CHAR(m.transaction_date, l_date_format),
3356: revision
3357: FROM mtl_material_transactions m,
3358: mtl_transaction_lot_numbers l,
3359: wms_item_locations_kfv lc
3360: WHERE l.transaction_id = m.transaction_id
3361: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3362: AND m.organization_id = p_organization_id

Line 3437: mtl_transaction_lot_numbers l,

3433: lc.concatenated_segments,
3434: TO_CHAR(m.transaction_date, l_date_format),
3435: revision
3436: FROM mtl_material_transactions m,
3437: mtl_transaction_lot_numbers l,
3438: wms_item_locations_kfv lc
3439: WHERE l.transaction_id = m.transaction_id
3440: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3441: AND m.organization_id = p_organization_id