APPS.GME_MOBILE_TXN dependencies on MTL_LOT_NUMBERS

Line 1303: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api

1299: IS
1300: l_return_status VARCHAR2(1) ;
1301: l_msg_data VARCHAR2(3000) ;
1302: l_msg_count NUMBER ;
1303: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1304: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1305: l_api_version NUMBER;
1306: l_init_msg_list VARCHAR2(100);
1307: l_commit VARCHAR2(100);

Line 1304: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api

1300: l_return_status VARCHAR2(1) ;
1301: l_msg_data VARCHAR2(3000) ;
1302: l_msg_count NUMBER ;
1303: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1304: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1305: l_api_version NUMBER;
1306: l_init_msg_list VARCHAR2(100);
1307: l_commit VARCHAR2(100);
1308: l_validation_level NUMBER;

Line 1315: FROM mtl_lot_numbers

1311:
1312: /* Cursor to check if a lot already exists*/
1313: CURSOR c_lot_exists IS
1314: SELECT 1
1315: FROM mtl_lot_numbers
1316: WHERE organization_id = p_org_id
1317: AND inventory_item_id = p_inventory_item_id
1318: AND lot_number = p_lot_number ;
1319:

Line 1976: mtl_lot_numbers n

1972: FROM
1973: gme_pending_product_lots l,
1974: mtl_transaction_reasons r,
1975: gme_material_details m, -- nsinghi bug#5236906. Add join to gme_material_details and MLN
1976: mtl_lot_numbers n
1977: WHERE
1978: l.batch_id = p_batch_id AND
1979: l.material_detail_id = p_material_detail_id AND
1980: l.lot_number = NVL(p_lot_number, l.lot_number) AND

Line 2039: mtl_lot_numbers n

2035: FROM
2036: gme_pending_product_lots l,
2037: mtl_transaction_reasons r,
2038: gme_material_details m,
2039: mtl_lot_numbers n
2040: WHERE
2041: l.batch_id = p_batch_id AND
2042: l.material_detail_id = p_material_detail_id AND
2043: l.lot_number = NVL(p_lot_number, l.lot_number) AND