APPS.GME_MOBILE_TXN dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 798: mtl_transaction_lot_numbers l

794: SELECT m.revision,lot_number,
795: ABS(SUM (NVL(l.primary_quantity,0))),
796: ABS(SUM (NVL(l.secondary_transaction_quantity,0)))
797: FROM mtl_material_transactions m,
798: mtl_transaction_lot_numbers l
799: WHERE l.transaction_id = m.transaction_id
800: AND lot_number = NVL(p_lot_number, l.lot_number)
801: AND m.organization_id = p_org_id
802: AND m.transaction_source_id = p_batch_id

Line 986: FROM mtl_transaction_lot_numbers

982: lot_number,
983: transaction_quantity *(-1),
984: primary_quantity *(-1),
985: secondary_transaction_quantity *(-1)
986: FROM mtl_transaction_lot_numbers
987: WHERE transaction_id = p_transaction_id AND
988: lot_number = NVL(p_lot_number, lot_number);
989:
990: EXCEPTION

Line 3454: mtl_transaction_lot_numbers l,

3450: lc.concatenated_segments,
3451: TO_CHAR(m.transaction_date, l_date_format),
3452: revision
3453: FROM mtl_material_transactions m,
3454: mtl_transaction_lot_numbers l,
3455: wms_item_locations_kfv lc
3456: WHERE l.transaction_id = m.transaction_id
3457: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3458: AND m.organization_id = p_organization_id

Line 3533: mtl_transaction_lot_numbers l,

3529: lc.concatenated_segments,
3530: TO_CHAR(m.transaction_date, l_date_format),
3531: revision
3532: FROM mtl_material_transactions m,
3533: mtl_transaction_lot_numbers l,
3534: wms_item_locations_kfv lc
3535: WHERE l.transaction_id = m.transaction_id
3536: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3537: AND m.organization_id = p_organization_id